Trap loss of connection

C

CyberDwarf

Using Access VBA with Sql Server
Users getting connection failure errors with our ADE due to timeouts, after
being away from the workstation for a while.

Also... I know I can check the CurrentProject.Connection.IsConnected
property and
re-establish the connection with 'CurrentProject.OpenConnection
(BaseConnString)',
but how do I trap the CurrentProject.Connection OnClose event globally from
within a running ADE?

Any hints/suggestions greatly appreciated

TIA

Steve
 
A

aaron.kempf

you should give a lot more information

I would just reccomend finding a new DBA: someone is out there killing
stale connections for no reason
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CurrentProject.Connection failure 3
SqlServer2005 with Win2k workstations running Access 2003 8
Using Access 2007 to connect to SQL 2
Test Connection to SQL Server 7
Complicated Connection Problems bewteen ADP and SQL Server 5
Cannot Integrate work BCM/OA07 together 1
connection issues - 5086 0
Access Project (adp) with Sql Server 2000 - First Connection Latency 13

Top