Access Database Manipulation

[mateo107]

In my program, I'm going to give users the option to "purge" the database of older records. So, I need the following to work behind the scenes.

I'm going to create a "duplicate" database, with the same table structures as the original, however, this database is going to have no data in it. I need the program to

a) copy this database (named templatedb.mdb) from the root of the App.Path folder, to the same location as a file named: archive.mdb

b) then, i'm going to scan the records in the current db (which I know how to code) , but how do i move the record (exactly as it exists) to the archive.mdb file and then delete it from the old database (db1.mdb)

I know how to work with recordset information (as in rs.MoveFirst, rs.edit, rs.update), but I'm not sure how to copy the database and not sure how to copy the whole record and then delete it.

ANy ideas? (BTW this is an access 97 mdb file)