undocking laptop causes adp to lose connection

  • Thread starter Thread starter brian
  • Start date Start date
B

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
 
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
 
Tom van Stiphout said:
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.
Click to expand...

But other software seems to keep on going seamlessly.
Wireless connections are a recipe for corruption, although much less
so with ADP.
Click to expand...

How is corruption even a problem with a SQL Server, or similar
product, for data storage on a wireless connection.

Tony
 
Tony Toews said:
But other software seems to keep on going seamlessly.
Click to expand...

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.
 
Douglas J. Steele said:
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.
Click to expand...

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 said:
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.
Click to expand...

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
 
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
Click to expand...
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
 
Back
Top