undocking laptop causes adp to lose connection
brian
undock my computer and go to wireless the application loses it's
connection to SQL Server. I have to close the application and resign
back in to get the connection back when in wireless mode. Any ideas
on how to fix this?
Thanks, Brian
Tom van Stiphout
wrote:
That is by design. You are cutting your wired connection. You can't
expect Access to simply jump to the wireless connection and keep
going.
Wireless connections are a recipe for corruption, although much less
so with ADP.
-Tom.
Microsoft Access MVP
Tony Toews [MVP]
>That is by design. You are cutting your wired connection. You can't
>expect Access to simply jump to the wireless connection and keep
>going.
But other software seems to keep on going seamlessly.
>Wireless connections are a recipe for corruption, although much less
>so with ADP.
How is corruption even a problem with a SQL Server, or similar
product, for data storage on a wireless connection.
Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/
Douglas J. Steele
news:g7bg55tu8mfbvsebs...@4ax.com...
> Tom van Stiphout <tom7744...@cox.net> wrote:
>
>>That is by design. You are cutting your wired connection. You can't
>>expect Access to simply jump to the wireless connection and keep
>>going.
>
> But other software seems to keep on going seamlessly.
But I'm not sure that if you, say, had a Word document or an Excel workbook
open and tried it that you wouldn't experience corruption.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
Tony Toews [MVP]
>>>That is by design. You are cutting your wired connection. You can't
>>>expect Access to simply jump to the wireless connection and keep
>>>going.
>>
>> But other software seems to keep on going seamlessly.
>
>But I'm not sure that if you, say, had a Word document or an Excel workbook
>open and tried it that you wouldn't experience corruption.
No argument there. But I've had other software, such as RSS Bandit,
that works equally well when I'm hooked via wired or wireless
connection when at home.
Tony Toews [MVP]
>No argument there. But I've had other software, such as RSS Bandit,
>that works equally well when I'm hooked via wired or wireless
>connection when at home.
Works equally well was the wrong phrase to use there. I should've
said something like the switch over between wired and wireless is
transparent.
Klaus-Dieter Gundermann
says...
> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
>
> >>>That is by design. You are cutting your wired connection. You can't
> >>>expect Access to simply jump to the wireless connection and keep
> >>>going.
> >>
> >> But other software seems to keep on going seamlessly.
> >
> >But I'm not sure that if you, say, had a Word document or an Excel workbook
> >open and tried it that you wouldn't experience corruption.
>
> No argument there. But I've had other software, such as RSS Bandit,
> that works equally well when I'm hooked via wired or wireless
> connection when at home.
>
> Tony
>
protocol.
Some software only needs a connection to the server for a short time:
e.g loading the word document in memory, checking for new RSS messages.
But a connection to a SQL server ( or Access MDB backend ) will be
opened when Access starts and stays open all the time until the application
closes.
Reason for this is, opening an connection for every single SQL statement
would be very slow.
So when cutting the wireless connection you are cutting Access connection
to the SQL server / MDB backend too.
btw when you are cutting your wireless connection just in the moment
when you are saving a Word document, you may corrupt your Word document too ;-)
Hth
Klaus
gabriel moreno
"Tony Toews [MVP]" <tto...@telusplanet.net> escribi� en el mensaje de
noticias news:bljh551hvmtlcl285...@4ax.com...
