Backup Data

[John]

Hi,
My Database is split, front and backend. If I use the backup utility in
Access 2003, only the front end is backed up as the tables are still linked
to the
original backend.

How do I create a backup of the data tables only?

Regards

John

 

[John]

Hi again
If backing up data tables is possible, I would like this to be done from a
form with a prompt to save the tables to a database of my Location and Name
choice.

Any Ideas?

Regards

John

 

[Allen Browne]

John, there is not a safe way to back up an mdb while it is in use.

If you think that anything is better than nothing, you can use the code in
the link below to create a new database and copy all the records in. If the
code stumbles on a table (e.g. a user has it exclusively locked at the
time), it just skips that table and goes no with the others, logging the
fact that the table was skipped. The copy if makes can be inconsistent. For
example if it backs up the Client table, and then before it gets to backup
the Invoices table some user (or process) adds a new client and an invoice
for that client, then when the backup routine does backup the invoice table,
there is an invoice for a client that is not in the backed up clients table.

If you are happy with those limitations, here's the link:
http://allenbrowne.com/unlinked/Backup.txt

The code does allow you to mark tables that you do not want backed up.

 

[John]

Thanks Allen
A few limitations I can possibly live with but the proof is yet to be seen.

Kind Regards

John

 

[Cydney]

How appropriate that I should come across this post when I'm trying to
accomplish the same thing today! I have a question about the MarkForNoBackup
property however. How do I set that? I have several odbc connected tables
that I don't need to backup. How do I mark them for no backup?

 

[Cydney]

And now I've just answered my own question...
I now see that you can exclude other file types in the "if not(..." portion
of the "BackupData" function.