auto numbering

L

LD

I am working in a 9000 record Access database and adding records. Somehow
the auto number is way off. The autonumber should be a four digit number but
is now an 8 digit number. How do I correct this to get the autonumbering to
get back in order?

Thanks

LD
 
R

Rick Brandt

LD said:
I am working in a 9000 record Access database and adding records. Somehow
the auto number is way off. The autonumber should be a four digit number but
is now an 8 digit number. How do I correct this to get the autonumbering to
get back in order?
Click to expand...

Deja-Vu all over again...

If you care about the value in ANY way other than uniqueness, then DON'T use an
AutoNumber. Their only purpose is to provide a unique value for creating
relationships between tables and/or as surrogate Primary Keys.

They WILL develop gaps (sometimes big ones) and they can even go negative. They
cannot be reliably used as a record "counter".
 
A

Allen Browne

Remove any records that have the 8-digit number, and then compact the
database:
Tools | Database Utilities | Compact.

If that does not solve the problem, you need to download the lastest service
pack for your version of Office, and also for JET 4. Both are available from
the Downloads section at support.microsoft.com.
 
Top