Connection timeout dialog

Hi,
When I am trying to open Access 2003 report after SQL server is stopped I
am getting following error:
---
Microsoft SQL Server Login
---
Connection failed:
SQL Server Error: 53
SQL Server does not exist or access denied.
---
Our requirement is to supress this error dialog and instead show customized
msg.
Any pointer how to supress error dialog in SQL msde because of connection
failure will be of great help....
Cheers,
BinodAbhi poddar (Abhipoddar@.discussions.microsoft.com) writes:
> When I am trying to open Access 2003 report after SQL server is
> stopped I am getting following error:
> ---
> Microsoft SQL Server Login
> ---
> Connection failed:
> SQL Server Error: 53
> SQL Server does not exist or access denied.
> ---
> Our requirement is to supress this error dialog and instead show
> customized msg.
> Any pointer how to supress error dialog in SQL msde because of connection
> failure will be of great help....
You would have to trap it with an ON ERROR and the look at the .Errors
collection. Presuming, that is, that you are using ADO. If you use DAO,
I don't have a clue.
In any case, this does not have much to do with SQL Server, but is something
you need to address in Access, so I would recommend asking in an Access
newsgroup.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp