AutoNumber reset ? (1 Viewer)

[joltremari]

I've been working on this db for a while and doing some testing along the way. Now I'm ready to put it into use and the field I have for ID which is the primary key and set to autoNumber starts at 75 because of all the testing I've done up to this point, even though all the records I used to test with have been deletetd. I need to know if there is any way to reset it so when we start using the DB the autonumber field will start at 1.

thanks for any help,

JO

 

[NightPort]

An easy way to do this would be to first delete your relationships and then change primary key to number. save it. then change it back into autonumber. Then re do your relationships. should take like 5 minutes.

 

[David R]

Even faster: Delete all records in the table, then compact the database. Your autonumber field will reset.

 

[joltremari]

Sorry NightPort but that didn't work.

David R - that worked. (salute)

I certainly appreciate your suggestions

JO