primary key (autoincrement) format troubleshooting

  • Thread starter Thread starter michael munson
  • Start date Start date
M

michael munson

I have a database of several thousand records.

Withot making any changes to the database, but in entering
new data today, the format of my primary key (which is an
auto-increment/number type of field) changed from
numbering records like 2023, 2024, 2025, etc. to
453053862, 453053863, 453053864, etc.

I use the ID number when I work with this data and NEED it
to be inline with what it had been.

Any ideas?

michael munson
(e-mail address removed)
 
Delete the records with the crazy numbers.
Then compact the database: Tools | Database Utilities | Compact.

To prevent it recurring, download the latest service pack for JET 4 from
support.microsoft.com (downloads section).

In Access 2000 and later, it is also possible to use ADOX to reset the Seed
of the autonumber. Example:
http://allenbrowne.com/ser-40.html
 
Back
Top