Resetting tables

[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

 

[Bruce M. Thompson]

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?.

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).