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.
 
Back
Top