Trap loss of connection

  • Thread starter Thread starter CyberDwarf
  • Start date Start date
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
 
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
 
Back
Top