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

[CodeManSeattle]

Is there any systematic way of intercepting the error messages from sql
server on a bound form?

 

[Tom van Stiphout]

On Mon, 10 Nov 2008 16:37:02 -0800, CodeManSeattle

Check out the Form_Error event?

-Tom.
Microsoft Access MVP

 

[CodeManSeattle]

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?

 

[Paul Shapiro]

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.