Catch Error Message Tables Not Connected

[jokobe]

I have a frontend and backend database. With my desktop it is on drive D:,
with my laptop it is on drive E:
How can I catch the error message at start up "Tables not connected". This
happens every time I move the frontend between the two comps. I just want to
reconnect when the frontend has been moved.

thx in advance for any hint

jokobe

 

[roger]

A workaround and not a FIX is the DOS Subst command.

The Subst command "subst"itutes a drive letter for a folder path.
(like a local mapped drive)
on one computer:

subst z: d:\mydatabase

and on the other machine

subst z: e:\mydatabase

then link all your MDB tables to Z:

you run the subst command from Start Run... or from a prompt, or save it in
a batch file (even AutoExec.bat) just do it BEFORE you open the MDB

I often link tables to mapped drives on LANs, and then use Subst when I
take a copy to a standalone machine.
see DOS command Subst /? for help

hth
rogher

 

[jokobe]

thanks Roger,
a very helpful workaround, I tried it and it is working...

jokobe