471,086 Members | 1,103 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,086 software developers and data experts.

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

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
3 1496
NeoPa
32,342 Expert Mod 16PB
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
jaidev
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
32,342 Expert Mod 16PB
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.

Similar topics

6 posts views Thread by kwijibo28 | last post: by
reply views Thread by Lucifer | last post: by
3 posts views Thread by ibn4n | last post: by
5 posts views Thread by Timo | last post: by
125 posts views Thread by jacob navia | last post: by
5 posts views Thread by Dean Slindee | last post: by
27 posts views Thread by RobG | last post: by
13 posts views Thread by Gabriel Genellina | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.