Fixing Autonumber format

[JoeAccess381]

My database was doing incremental records using autonumber. Then, my
database locked up in an "unexpected state". Our systems people were able to
recover the database, but now all tables in the database with Autonumber
columns are listed as random and not incremental.

Is there a way to get back my incremental format from random? WIll I have
to export the data to another database and reformat?

All help is appreciated.

Joe

 

[Jeff Boyce]

Joe

Your question implies that you are using (i.e., viewing) the autonumbers as
meaningful (i.e. your "sequence" numbers). Access Autonumbers are designed
to provide a unique row identifier, and are not guaranteed to be sequential.

If you absolutely, positively need to have a sequential ID (not necessarily
your row identifier), check mvps.org/access or google.com (ms access group)
for "custom autonumber" listings.