CurrentProject.Connection failure

  • Thread starter Thread starter CyberDwarf
  • Start date Start date
C

CyberDwarf

Help!!

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

I can save the connection string and create a new ADO connection from there,
BUT...
the CurrentProject.Connection is read-only, so how do I reconnect the
project? Or do I force application closure & restart?

Also... I know I can check the CurrentProject.Connection.State property,
but how do I trap the CurrentProject.Connection OnClose event globally from
within a running ADE?
I have approx 150 forms in the project, so where would I code the OnClose
event???

Any hints/suggestions greatly appreciated

TIA

Steve
 
Mmmm...
I could use CurrentProject.OpenConnection(ConnString)
But I would still like to trap the connection close event

Any ideas?

Steve
 
I think that you're crazy dog

just cleanup the connection when you open it and leave your extra crap
in there until someone re-uses that SPID
 
Flattery will get you everywhere....
I think that you're crazy dog

just cleanup the connection when you open it and leave your extra crap
in there until someone re-uses that SPID
Click to expand...
 
Back
Top