Resetting Autonumber fields

[notoca]

Hi

After testing tables with dummy data and deleting the dummy data how can the autonumber key fields be reset to starting from 1?

Thanks

Russell

 

[bat17]

You can sometimes reset them by compacting the database. However Autonumbers are not designed to give you sequential numbers for things like invoices and should be used in the background for key fields and things where you need a unique ID.
Autonumbers will leave gaps in the number sequence if somebody cancels a record after they start filling it in.

HTH

Peter

 

[Mudface]

I think you would need to delete the field, save your table then stick it back in and resave (obviously you will also need to delete any relationships based on the field, too and then recreate them). As bat17 says, though, it doesn't really matter what the number is, as long as it's unique. If you do want a sequential number, take a look at Candace Tripp's website and download the Autonumber without Autonumber database-

http://www.candace-tripp.com/access_downloads.htm