Clear Database and Reset the AutoNumber

[jillian.calderon]

Good Morning Everyone,

I'm making a database and I'm playing with it using test data. When
I want to put the actual data in, how do I reset the autonumber back to
1? How do I tell the database to completely delete the fake records so
the autonumber doesn't start at, o, 50?

Thanks!
Jillian

 

[Al Camp]

Jilian,
Delete all the records in your table, and then Compact and Repair the database.
Your first new record should be 1.

 

[jillian.calderon]

I didn't even notice there was a way to compact the database.
Thank you!!!

 

[Ron Weiner]

In addition to Al's solution to reset the autonumber to 1, you can find a
code snipit here http://www.worksrite.com/ReSetAutoNumber.htm that will
allow you to (re)set the autonumber seed and increment to any values you
like.