Neat archiving code to make backups of the mdb tables.

This was created by: Sinndho (I posted it here because I thought it appropiate for the code bank.)

Sinndho comments...
Here you are: this new version can archive records from a local table and records from an Access linked table.

Everyone: Please keep in mind that this program is just a skeleton (if I may say so!) and several important features are missing:
First, an error handling mechanism should be implemented. The structures to detect errors are in place but these are not handled properly.
Second, only a few cases among many other possible situations that could be met in a production environment are handled.

If you want to test the program using the form Archive_Form, the file ArchiveDatabase.mdb can be anywhere on the computer
however the second file Sales.mdb that contains a table that is attached in ArchiveDatabase.mdb must be located in the
C:\Data folder (or you have to change the attachment). As it is the archive database Sales2008.mdb will be created in the
C:\Archives folder but this can easily be changed.

Have a nice day!