Capturing returned ODBC error message using form_Error
- From: "sjlevine34" <sjlevine34@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 24 Jun 2005 07:49:16 -0700
I have written an application with an Access front end to an Oracle Database.
All security and data validation is in the Oracle database, including
user-defined error messages. These error messages are returned as ODBC--
linked failed and, when occurring in a VBA module, the specific
Oracle-generated message may be retrieved from
dbEngine.errors(0).description. However when I try to access the error
message in dbEngine errors while in the forms.Errors event, it is not there.
I would very much like to capture it so that I can extract the meaningful
portion using mid, left and right and display it as a user-friendly message.
I know it is preserved somewhere in Access because, unless you make response
= acDataErrContinue, it displays in Access's own error message box after
form_error completes. Is there any way I can retrieve this message during
the forms_Errors event?
sjl
--
sjl
.
- Follow-Ups:
- Re: Capturing returned ODBC error message using form_Error
- From: Van T. Dinh
- Re: Capturing returned ODBC error message using form_Error
- Prev by Date: Re: import to access from delimited file - file fields have change
- Next by Date: converting text to date
- Previous by thread: How do I insert jpeg file into Microsoft Access database?
- Next by thread: Re: Capturing returned ODBC error message using form_Error
- Index(es):
Relevant Pages
|
