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




CyberDwarf wrote:
> Mmmm...
> I could use CurrentProject.OpenConnection(ConnString)
> But I would still like to trap the connection close event
>
> Any ideas?
>
> Steve

Flattery will get you everywhere....
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>
>
>
>
> CyberDwarf wrote:
>> Mmmm...
>> I could use CurrentProject.OpenConnection(ConnString)
>> But I would still like to trap the connection close event
>>
>> Any ideas?
>>
>> Steve
>