Reset Autonumbers

J

Jim/Chris

Delete all the records from your table and compact the
database. The autonumber will start at 1. Remember you
will always have gaps due to deleted records.

Jim
-----Original Message-----
I have set up my database with lots of test records over time.

Now I am ready to roll out!

How do I easily reset the record numbers back to 1 for all
Click to expand...
my table autonumber fields whether joined by relationships
or not?
 

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

Adding data to MS Access from csv file 0
Reset Autonumber 2
Excel VBA to delete records in Access table and reset the Autonumber 1
Autonumber records inserted in gaps 0
Autonumber reset 1
resetting autonumbering to 1 4
AutoNumber Field Limits - NOT "How do I reset?" 11
Autonumber Macro 3

Top