General discussion
August 24, 2003 at 11:31 PM
martinpr

Reset Access Autonumber after deletion

by martinpr . Updated 23 years ago

In previous versions of Access the counter on a Autonumber field could be reset to the next highest number, following a deletion of the most recent record, by compacting the database.
In Access 2000 this does not appear to work. the only way I have found is to import the table into a new database. Not a very practical solution. Any sugestions?

This discussion is locked

All Comments