Database state

A

Abhi poddar

Hi Friend,
We are fetching data for access 2003 report from linked table.
Table are in SQL server. So before opening the report we check whether SQl
server is running or not, so that we can show customized error msg when sql
is not running.
We are able to ascertain whether sql connection exist or not before opening
the report.
PROBLEM : But while sql server database backup is being taken and report is
opened then error is shown saying particular view or table doesnot exist. We
want to catch this error and show customized error msg.

Any help on this will be great .....

Cheers,
Alpha
 
Top