Delete data and start over - autonumber problems?

[Acipenser]

I have basically gotten my database how I want it, but while testing certain things I have entered a lot of useless data. How do I delete the data and return all autonumber fields to 1 (basically start over).

Thanks,

 

[psemianonymous]

Compact the database and it will return to the appropriate number.

Keep in mind that during the course of usage autonumbers WILL skip.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm