undocking laptop causes adp to lose connection

[brian]

I have an Access project (A2000) that I am running. Everytime I
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]

On Fri, 10 Jul 2009 10:37:00 -0700 (PDT), brian <[email protected]>
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

 

[Douglas J. Steele]

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.

 

[Tony Toews [MVP]]

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

 

[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.

Tony

 

[Klaus-Dieter Gundermann]

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

Thats the difference between a connection oriented and a connectionless
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]

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.

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/

 

[chrise]

Why not use the wireless connection when you are docked?

 

[wa1]

Why not use the wireless connection when you are docked?

 

[paulo silva]