Handling odbc errors on a sql server backend with a bound form

  • Thread starter Thread starter CodeManSeattle
  • Start date Start date
C

CodeManSeattle

Is there any systematic way of intercepting the error messages from sql
server on a bound form?
 
On Mon, 10 Nov 2008 16:37:02 -0800, CodeManSeattle

Check out the Form_Error event?

-Tom.
Microsoft Access MVP
 
I have. Unless I am missing something, all I see is the ability to look at
error messages within access. For instance I only get the general 3146 ODBC
call failed message. I dont see a way off retrieving the message from the
backend sql server. Do you know how?
 
I think you have to check the errors collection on the connection. I've done
this with a new connection created in code, but you might also be able to
get the errors collection from the builtin Access connection.
 
You must log in or register to reply here.

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

ODBC Update on a linked table 'table name' failed 1
read ODBC Connection 7
You must use the dbSeeChanges option with OpenRecordSet whenaccessing a SQL Server table that has an 1
Copy Record Problem 3
Error handler not catching SQL Server Connection failure 2
Handling ODBC errors on bound form 1
SQL Server Backend: linked tables or no more bound forms ? 4
Problem navigating beyong the last record 1

Back
Top