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

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.

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

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