Resetting all autonumbers in database

  • Thread starter Thread starter Michael San Filippo
  • Start date Start date
M

Michael San Filippo

does anyone have a fuction that will reset ALL the autonumbers in a
database?

I have to set up a blank database w/ all the autonumbers reset and i have
hundreds of tables.

HELP ;-)
 
Just compact the database (Database Utilities from the Tools menu).

If that does not work, you need to download the latest service pack for your
version of Office from support.microsoft.com
 
Sure nuff - i thought that just fixed corrupted records ;-) thanks a bunch
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reset autonumber 1
Restarting AutoNumber 5
AUTONUMBER reset 7
delete autonumber memory 2
Autonumber fields in MS Access 6
Access 5
Access Sequentially numbered column that resets with each new sample 0
Creating and populating a table 3

Back
Top