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
ADO Connection question 0
CurrentProject.Connection failure 8
"Error in Loading DLL" at currentproject.connection on different machine 4
Access 2K CurrentProject.Connection 0
urgent help: CurrentProject.Connection 3
Change connection string in Access project 0

Top