Resetting tables

  • Thread starter Thread starter Paul Hayes
  • Start date Start date
P

Paul Hayes

Have a table I want to reset a table that uses automeric
numbers for the index (key). I have deleted the entries
in the table because I want to start again, but the index
keeps incrementing from it's previous value. I want put
to the index, or record from 0, not for example 7. How do
I do
this?.

Your help would be great.

Thanks

Paul
 
Have a table I want to reset a table that uses automeric
numbers for the index (key). I have deleted the entries
in the table because I want to start again, but the index
keeps incrementing from it's previous value. I want put
to the index, or record from 0, not for example 7. How do
I do
this?.
Click to expand...

While there are no records in the table, compacting the MDB file should reset
the autonumber field back to zero (first record will be 1).
 
Back
Top