Handling odbc errors on a sql server backend with a bound form CodeManSeattle 11/11/2008 12:37:02 AM Is there any systematic way of intercepting the error messages from sql server on a bound form?

Re: Handling odbc errors on a sql server backend with a bound form Tom van Stiphout <tom7744.no.spam[ at ]cox.net> 11/11/2008 3:34:37 AM On Mon, 10 Nov 2008 16:37:02 -0800, CodeManSeattle <CodeManSeattle[ at ]discussions.microsoft.com> wrote: Check out the Form_Error event? -Tom. Microsoft Access MVP [Quoted Text] >Is there any systematic way of intercepting the error messages from sql >server on a bound form?

Re: Handling odbc errors on a sql server backend with a bound form CodeManSeattle 11/11/2008 4:17:01 AM 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? "Tom van Stiphout" wrote: [Quoted Text] > On Mon, 10 Nov 2008 16:37:02 -0800, CodeManSeattle > <CodeManSeattle[ at ]discussions.microsoft.com> wrote: > > Check out the Form_Error event? > > -Tom. > Microsoft Access MVP > > > >Is there any systematic way of intercepting the error messages from sql > >server on a bound form? >

Re: Handling odbc errors on a sql server backend with a bound form "Paul Shapiro" <paul[ at ]hideme.broadwayData.com> 11/11/2008 2:12:14 PM 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. "CodeManSeattle" <CodeManSeattle[ at ]discussions.microsoft.com> wrote in message news:51F035DB-E10E-4EE5-B3F9-2C5D4EBAD3FF[ at ]microsoft.com... [Quoted Text] >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? > > "Tom van Stiphout" wrote: > >> On Mon, 10 Nov 2008 16:37:02 -0800, CodeManSeattle >> <CodeManSeattle[ at ]discussions.microsoft.com> wrote: >> >> Check out the Form_Error event? >> >> -Tom. >> Microsoft Access MVP >> >> >> >Is there any systematic way of intercepting the error messages from sql >> >server on a bound form?