relinking to network tables after dialup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mark baker - 24 Nov 2003 17:22 GMT

We have an Access application that links to tables in a
database on a Windows NT Server. This application also
utilises a dial-up connection which of course temporarily
disconnects the network. The problem comes when you are
connected via dial-up for more than a couple of minutes.
Then, if you disconnect the modem and try and reconnect to
the server, you get a "disk or network error". The code
that fails is that which is trying to relink the tables -
it simply won't do it! If you're connected via modem for
less than two minutes, then disconnect, the network link
reestablishes fine - the tables relink fine.

Help please!

Reply to this Message

david epsom dot com dot au - 25 Nov 2003 04:05 GMT

> utilises a dial-up connection which of course temporarily
> disconnects the network.

Only because your IT people have configured it to do so,
for security (so that the dial-up connection is never
connected to your network).

> the server, you get a "disk or network error". The code
> that fails is that which is trying to relink the tables -

Does it work better if you try to create new links,
instead of refreshing the old links?

If necessary, delete the old links before the network
goes down, then try to create new links after it
comes back. You may have to put a small delay in,
to wait for the network to come back before you
try to use it.

(david)

> We have an Access application that links to tables in a
> database on a Windows NT Server. This application also
[quoted text clipped - 9 lines]
>
> Help please!

Reply to this Message