Fixing Autonumber format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top