CurrentProject.Connection failure

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
 
C

CyberDwarf

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

Any ideas?

Steve
 
L

larrylinsonjr

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
 
C

CyberDwarf

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...
 

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

Trap loss of connection 1
ADO Connection 2
"Error in Loading DLL" at currentproject.connection on different machine 4
where to dig out "access 2003 developer extensions" 2
CurrentProject.Connection failure 8
urgent help: CurrentProject.Connection 3
adp Connection to SQL Server 2
ADP works, ADE on same machine does not 6

Top