Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001

    Question Unanswered: Error handling on ODBC-bound form

    Hi there,

    here's my little problem:

    I have a form that is bound to a linked ODBC-table (SQL-Server 2000)
    When the users omits a required field, an error message pops up telling that the ODBC-Call failed because I can't have NULL values in that column.

    I tried to trap that error in the form_error-event. That works fine except it gives me the Access-error number 3146 (application defined error) only.

    Checking the Application.Errors-Collection didn't return the full ODBC error message.

    Is there a way of getting the full ODBC error message???

    Any help is greatly appreciated!


  2. #2
    Join Date
    Oct 2001
    Bay Area, CA
    msgbox "error number: " & err.number & " error description: " & err.description

Posting Permissions

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