Wooohooo! Yes, now we're getting where I need to be! I'm learning so much day to day with VB, but there are still lots that I don't know (obviously)...

Thank you all for your latest responses... to respond to your inquiries...

My program is going to be distributed with the actual database (db1.mdb) as well as the "template" database, which will be empty from data, but will contain the proper tables as (same as) db1. So,

I was planning on coding my "archive" button to do just what RobDog was suggesting... Copy template.mdb (single user - unopened database) to the folder App.Path\Archive\MM-DD-YYYY_backup.mdb.

THEN I'd cycle through each record in my table to look and see if the "Archive" property was set = True. If it was, I want to copy that record to the MM-DD-YYY_backup.mdb and then delete it from db1. Then, probably I'll run a repair/compact as suggested above to clean up db1.

Based on this, do we have all the code in these posts to accomplish what I'm looking for? How would I copy and then rename template.mdb without user intervention?

Thanks so much! ! ! I'm soo very close to finish thanks to all the good people at VBForums.com! I can't wait for everyone who's helped me to see the final product!!! :-D