Verify ODBC Connection Available

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an application with Access as frontend and SQL as backend, using ODBC.
When the User logs on thru his/her frontend, I need the Access frontend to
verify that they are online and the connection to SQL is available, otherwise
I need to restrict their activities to limited offline functions.

How can I have Access verify that the ODBC connection is available?? I
suppose using a timeout error check is one method but is there something
quicker and more reliable.

Thanks
 
How about reating a query based on a table that uses ODBC to return the count
of records - if the result is nil or an error then restrict the users to
offline functions?
 
Thanks for your response.

I've used essentially the technique you recommended; namely called a stored
procedure that will return one word if attached to the ODBC data source, but
a timeout error if not. I was hoping to find a different approach in order
to avoid the User having to wait (usually ~ 20 sec) for the timeout error.
 
Back
Top