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
 
Top