Table autonumbers - possible reset?

[Bob]

Can anyone suggest a possible solution. I am developing
an MS Access Application and in the course of development
I'm entering dummy data to verify functionality. At the
end of the development cycle I would like to wipe the
contents of the db and have all the autonumber fields
reset themselves so that when new entries are made the
real data that is being entered has autonumber entries
that begin again at 1.

Can anyone suggest a good way of being able to achieve
this?

Thanks
Bob

 

[tina]

after deleting the "dummy" records in the table(s), compact your database.