sql server connect: 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,

Abhi poddar (Abhipoddar@discussions.microsoft.com) writes:
[quoted text, click to view]

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