Reset Record Numbering

[Guest]

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.

 

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

 

[Guest]

Thank You! worked like a charm!

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.

 

[Joseph Meehan]

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.

I suggest you may not want to use Autonumber for that use. Autonumbers are
designed to provide unique numbers. It in not designed to provide numbers
in order and for a number of reasons may not do so. As a result using them
in any application where the user sees the numbers is likely to end up with
confusion.

There are other ways of providing the numbers you want depending on the
particual application.