ODBC data source unavailable message

[magick]

i have a database that uses ODBC to run queries and reports and would like to
have a more user-friendly error message when the data warehouse is down
(other than the default Access error messages). Thanks! i am running access
2003.

 

[Larry Daugherty]

In your Error Handler for the function or sub procedure in question
(*every procedure must have an Error Handler of some sort), Select
Case on the returned error. For case of the ODBC data source being
unavailable, put up a msgbox with your friendlier message and just the
OK button. When the user clicks OK, exit the procedure.

If you aren't yet putting in Error Handlers I recommend MZ Tools to
facilitate the job.

HTH