Copy or BackUp data from linked tables

[Sid]

I want to Copy a backend file or Copy the Data and Structure (Incl.
Relationships) from code in the front end. Is it possible?
So far I cannot "filecopy" because the file is in use.
Have tried to filecopy a blank copy of the database (Structure with no data)
and then transfer the data into it but the "Transferdatabase" method fails
because of the relationships. It tries to delete the tables.
Should I somehow drop the link to the backend and then filecopy and relink
or should I transfer the data to the blank copy and then set the
relationships??
Both these ideas seem a bit messy! Any ideas?

 

[Douglas J. Steele]

Dropping the link to the backend and then copying is probably the easiest.
Note that this doesn't mean that you have to unlink each of the tables
though. As long as none of your bound forms are open, you should be okay.
Certainly, that's how I compact my back-end databases from my front-ends.
Check to see whether the LDB file exists or not: if it doesn't, you should
be okay to copy.

 

[Sid]

Don't you just love it when the simple answer smacks you right between the
eyes!
Yep, the button was on a bound form! I moved it to another form and presto!
Thank you Mr Douglas J. Steele
As we say here in OZ, ONYA!

Dropping the link to the backend and then copying is probably the easiest.
Note that this doesn't mean that you have to unlink each of the tables
though.

That's what I was going to do! Re linking was then the next problem

 

[Douglas J. Steele]

Glad it helped.

BTW, for one way to relink, check out
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web"

 

[Sid]

Well I'll be buttered on both sides!
As it happens, my db is linked to two backend files.
One for data input and one for data output.
Your Relink code has just fixed my next dilema...
I tip my hat to you!
Again, ONYA!