Verify ODBC Connection Available

[jkm911]

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

 

[Snowsride]

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?

 

[jkm911]

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.