Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Israel
    Posts
    10

    Question Unanswered: catching "ODBC error -- failed" from Access

    Hi all,
    does anybody know how can i catch an ODBC error from Access evironment?
    the situation is - a user tries to delete a record inside the application.
    i insured that the DB will having an inforcing constraint that does not
    allow this, but i want the user to see a more friendly message instead
    of the ODBC message and what follows it.
    can i do it?

    thanks a lot,
    miri

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343

    Re: catching "ODBC error -- failed" from Access

    You can use err.raise method to capture the error and then can display your custmoized message.
    Check help files on it..

    Originally posted by Miri
    Hi all,
    does anybody know how can i catch an ODBC error from Access evironment?
    the situation is - a user tries to delete a record inside the application.
    i insured that the DB will having an inforcing constraint that does not
    allow this, but i want the user to see a more friendly message instead
    of the ODBC message and what follows it.
    can i do it?

    thanks a lot,
    miri

  3. #3
    Join Date
    Oct 2003
    Location
    Israel
    Posts
    10

    Re: catching "ODBC error -- failed" from Access

    Thank you so much , i will

Posting Permissions

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