ODBC Connectivity

[BD]

My MS Access 2003 mdb file is accessing a MS SQL Server back-end. I
have a couple of users utilizing laptop computers with the NexTel
aircard to access the internet. The pc card is cutting the connection
due to in-activity and when this happens they have to restart the
application. I have been unable to locate a solution to this problem.
I don't think refreshing the table links will solve this due to the mdb
technology. Any assistance would be helpful and greatly appreciated.

 

[Trey Davis]

ODBC usually doesn't work well with Microsoft Jet

Try a different IP address.

HTH

Trey Davis
Microsoft Access MVP

 

[BD]

You are absolutely correct about Jet. I am in the process of upgrading
the front end to C# programming, however, I have many things to
re-learn. I know .net technology is more suited to this. I was hoping
there might be a way to duplicate .net's ability to close and open
access points while working remotely. But I have been unsuccessful in
finding a way to do this. C# is the way I want to go if for no other
reason, it is easier to manage upgrading the program with One-Click.

 

[Guest]

Trey Davis is NOT a Microsoft MVP and I suggest not paying any attention to
his reply. If you review his recent posts you'll see that he has "issues".