On Wednesday 14 January 2004 03:29, Andreas wrote:
> Hi,
>
> Access 2000
> Postgresql 7.4.1
> newest PG-ODBC
>
> how can I check if a DAO- or ADO-connection is still alive ?
> I'd like to maintain a connection to a remote PG server within my VBA code.
> It should be opend when the users start the application and closed when
> the app terminates.
You could have a timer that calls a function that just runs "SELECT true" or
similar. If the query fails, you've lost your connection. Is that the sort of
thing you meant?
--
Richard Huxton
Archonet Ltd