Exit Before SQL Server Error Message

  • Thread starter Thread starter Matt.W.Stephens
  • Start date Start date
M

Matt.W.Stephens

I have an Access 2000 database with an SQL server backend.
When a user opens the database the switchboard calls for information on
the backend server. If the user does not have access to the SQL server
the "Microsoft SQL Server Error" message pops up.
SQL Error number 18456. And then prompts the user about using a trusted
connection or entering a new username password. I need to somehow catch
this default error message and display my own error message first and
then exit the database. Is it possible to prempt the default error
message?
 
Matt

Before the switchboard calls for the info, you could try opening a table
through VBA to see if you get an error. I don't know if you could trap it or
not, but it's worth a shot.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Server Backend is Read Only 7
Access and SQLServer Express 2005 3
Access frontend SQL backend - error 1
Form datasource from sql server backend 1
SQL Server Back End 2
Database Window Control 15
Best way to deploy Access read-only database that is linked to SQL tables 6
Trouble upsizing Access to SQL 5

Back
Top