Archiving with DAO

[craiggraham]

I want to archive with Access and also be able to search the archive and the current database when there is a query.

Any help to point me in the right direction is appreciated.

[Chuck Sweet]

Crazy, man, the way you spit that out like it's no big deal. That could get kind of complicated. Let's see, where to begin....

One of our techniques is creating a table for archived data, lets say a year back, in the regular database. Then, anything in that year can be easily searched just by accessing that table. After a year, we copy the stuff over to another db that we don't allow access to. If you want to zip your db, then you can get Xceed zip or some zip package. Xceed zip lets you zip and unzip your database on the fly, so you can use the temp directory or something when accessing the database archive.

in another program, though, i just copy the whole database upon exit. it really depends on the magnitude of the expected data. in any case, some good functions to remember are:

Kill (path as string) - deletes the specified mdb
FileCopy (source, destination)

To move data between tables, you could probably write a query on the database side of the house that does that.

-chuck