Re-establishing link to SQL from ACCESS XP (wireless)

Hi,
I am developing an ACCESS ADP that links to MS SQL, the SQL is on a server,
the ACCESS links to it via a wireless network. When it goes out of wireless
range, I will lose the link to the database. Is there a standard way to hav
e
it re-link effortlessly (quickly) when it comes back into range. I don't
want the operation to have to do anything.
Thanks,
SteveYou can write code to relink the tables. The Knowledge Base
used to have sample code to do this, the Access FAQ has
sample code - http://www.mvps.org/access/
-Sue
On Mon, 10 Apr 2006 13:40:02 -0700, SteveInBeloit
<SteveInBeloit@.discussions.microsoft.com> wrote:

>Hi,
>I am developing an ACCESS ADP that links to MS SQL, the SQL is on a server,
>the ACCESS links to it via a wireless network. When it goes out of wireles
s
>range, I will lose the link to the database. Is there a standard way to ha
ve
>it re-link effortlessly (quickly) when it comes back into range. I don't
>want the operation to have to do anything.
>Thanks,
>Steve