is there a way to force the auto number to be a positive number in access. as it keeps generating negitive numbers??
Have it start at 0 and increment by one.<BR><BR>How many do you have? Perhaps it's looped by now?
How?<BR>Access Primary Key
.. multiple users and/or synching the database w/ an offline copy.<BR><BR>Or something and something like that.<BR><BR>I don't know what to tell you - but, that should give you a start of what to look for.
This is an example of an "auto number" from a fox pro DB i've been working with:<BR>U^*&TGH%#<BR><BR>