Checking MS-Access Database table structure other than the opened database

[jaidev]

I am creating backup and restore facility for my access based program, backup is working fine where I simply extract tables to another database.

While restoring the same I would like to check whether the database structure is same or not or someone has tempered into it or may be user has selected a wromg file. How can I achieve this. Please help me out.

Thanks

Jaidev

[NeoPa]

Without any idea of how you have implemented your Backup/Restore it's very hard to give a sensible answer.

1. Is your backup required to backup individual parts?
2. Can you simply copy the .MDB files backwards and forwards?
3. Are you using a Front/Back end structure to your database(s)?

[jaidev]

Without any idea of how you have implemented your Backup/Restore it's very hard to give a sensible answer.

1. Is your backup required to backup individual parts?
2. Can you simply copy the .MDB files backwards and forwards?
3. Are you using a Front/Back end structure to your database(s)?

Hi,

Thanks for replying, yes I have just the single .mdb file which I use for back/front end both.

In backup I am just copying tables to another new database (mdb file) using docmd.transferdatabase acExport. So the backup file contains the tables which i have exported.

In restore I am looking to import these tables using the same process of acImport (I am simply deleting relationships, deleting tables then importing tables and making relationships) using VBA. but I am afraid if someone choose wrong backup file which actually dont contain the backup tables or deleted or changed the name. My process will delete the table and importing will not be done. So there will be loss of data.

That exactly I want to check before importing whether the backup file has correct table names or not and the fields are same or not.

I hope you havethe answer.


Thanks & Regards

Jaidev

[NeoPa]

To avoid the complexity try doing (A) Backup / (B) Restore as :

1. Compact and Repair to the Backup Database name.
2. Run a Batch (.Bat) or Command (.Cmd) file which copies the backup version over the top of this one (When you've closed the current one of course).

That way, the synchronising will be unnecessary.