Autonumber

[jfrasier]

After months/years of using this database when I add a new record to a
table, the autonumber field is starting with about 4450, even though
the numbers continue to 10321. Usually this creates an error because
it is duplicating a number from another record. I have compacted and
repaired the database.

Any ideas?

Thanks.

 

[Allen Browne]

For suggestions on the causes, and possible solutions, see:
Fixing AutoNumbers when Access assigns negatives or duplicates
at:
http://allenbrowne.com/ser-40.html

Note that if the table is attached, it is the back end database you need to
compact/repair. If that doesn't solve it, you may need to download a service
pack for JET 4 from:
http://support.microsoft.com/sp

In any case, the ADOX code in the article above will reset the seed of the
AutoNumber.