Capturing database errors??

Results 1 to 2 of 2

Thread: Capturing database errors??

  1. #1
    Big Mac Guest

    Default Capturing database errors??

    Hi,<BR>How do I capture errors like the following and display my own message rather than this one:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e14&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression &#039PRI =&#039. <BR><BR>/english/r2422368/order/order.asp, line 15 <BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Capturing database errors??

    Hi.<BR><BR>First you use the error-resume likes this:<BR>On Error Resume Next<BR><BR>and after the code that can generate the error you type this:<BR>if Err.Number = 80040e14 then<BR> do SomeThing<BR>End if<BR><BR>I have only used this once, on a diffrent error, but it should work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts