Unlink an external mdb ??

J

Jan Pit

I have an Acces mdb that with 7 linked tables. These are in the DATA1.mdb
At startup I check the links and relink if required.
This in fact locks that DATA1.mdb.
Now I want to make a backup file (say DATA2.mdb a new file) using the
CopyFile in VB.
But as DATA1.mdb is locked this fails.
Can I "unlink" DATA1.mdb temporarily and then relink it after making the
backup?
Or should I do this completely different?
TIA

+ Jan Pit +
Botswana
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unlink and Relink 2
Dynamic link to workbook 3
Queries losing fieldnames when importing from external mdb 2
password-protected external mdb via linked tables 0
Backup linked tables .mdb with VBA 1
Issues relinking to backend tables 9
linking external data 2
How to lock an MDB file, but yet allow application to access it 5

Top