By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,834 Members | 1,176 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,834 IT Pros & Developers. It's quick & easy.

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

P: 2
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
May 25 '07 #1
Share this Question
Share on Google+
3 Replies

NeoPa
Expert Mod 15k+
P: 31,770
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)?
May 26 '07 #2

P: 2
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
May 30 '07 #3

NeoPa
Expert Mod 15k+
P: 31,770
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.
May 30 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.