If you want to start from scratch every once in a while, I'd upload clean copy of the database and change the DSN to accomplish your task. Also, I wouldn't worry about running out of IDs unless you are doing something special. I would think Access would crash before reaching the max number of records in a db.
Paul
[
Todays Threads]
[
This Message]
[
Subscription]
[
Fast Unsubscribe]
[
User Settings]