Catch Error Message Tables Not Connected

  • Thread starter Thread starter jokobe
  • Start date Start date
J

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
 
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
 
Back
Top