I have a linked database that link to a master database. The problem I have is if I move the master database to another directory, the linked database cannot find where the master database now is. In that case, what should I do to link them again should the master database is moved to different directory ?
I wanna send to my friend these 2 files (linked DB and original DB). So when he saves it to his hard drive, will it still be linked, because the directory is already changed ? If not linked, let's say he moves the original DB to a different directory, can he link the linked DB to original DB without using Linked Table Manager, i.e. automatically done ?
I already tried the linked DB u told me earlier, it works fine.
Let's say I have my original and linked database in this directory:
F:OriginalDB.mdb ---> Network
Then my friend moves it to his drive:
G:OriginalDB.mdb ----> Network
I tried move the originalDB to D drive, then the linkedDB cannot find it, so I have to use Linked Table Manager to re-link it.
One thing for sure, my friend does not want use Linked Table Manager or re-link it manually, so the only way to detect a new directory automatically is by using VBA code ? My aim is I just send the files to him, and he can move the files (at least the originalDB) anywhere in his drive without worrying about re-link etc.
You may enconter some errors, due to diferent versions of access. But the main issue, the related tables, i think it is well examplified, see how it works, modify if you won't, say something if you don't understand.
Concerning to the code you post in last reply, i must say that i'm not very well familiard with that issue, that is some parts of the VB language that i never take a look, i'm sorry, but in that i can't help you.