Resetting all autonumbers in database

  • Thread starter Michael San Filippo
  • 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 ;-)
 
A

Allen Browne

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
 
M

Michael San Filippo

Sure nuff - i thought that just fixed corrupted records ;-) thanks a bunch
 

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
AutoNumber Reset 1
Access Sequentially numbered column that resets with each new sample 0

Top