Reset Access Autonumber field
Hi,
My client wishes to delete all previous record in the database....The last record number is 241 which corresponds to the last order made..Is there a way to reset the autonumber default value back to 1 once I delete all the records and start with a new record?
The field name is OrderNum(data type is: autonumber).
Hope you get my point....
:) :) :) Greg
Re: Reset Access Autonumber field
The first way I know is to perform a Compact & Repair on the database. This will reset the seed to the next number after the last record's autonumber id value.
Re: Reset Access Autonumber field
Hi.....
Thanks for the prompt reply...Yup, it did work...
However, are there any VBA coding applicable to this w/o using the compact and Repair Method?
:) :) :) Greg
Re: Reset Access Autonumber field
You can programmatically perform a C & R on the db but exclusive access is required.
Here is another way:
http://office.microsoft.com/assistan...&respos=1&rt=6