Reset Record Numbering

D

databaseboy2005

This seems like it should be easy....
You fill a database with records. First column is ID with autonumbering
turned on. Great. Now, when record number reaches 100 I would like to clear
this particular database and restart records at #1. I am using this with
Frontpage and dont want to create a new db every time. any ideas? Thanks in
advance.
 
S

Steve Schapel

Databaseboy,

After deleting all the records from the table, if you compact the
database (for example via the Tools|Database Utilities menu), the seed
for the AutoNumber will be reset to 1.
 
D

databaseboy2005

Thank You! worked like a charm!

Steve Schapel said:
Databaseboy,

After deleting all the records from the table, if you compact the
database (for example via the Tools|Database Utilities menu), the seed
for the AutoNumber will be reset to 1.
Click to expand...
 
Top