Re: Capturing returned ODBC error message using form_Error

See if the following Microsoft Knowledge Base article helps:

http://support.microsoft.com/?id=209855

--
HTH
Van T. Dinh
MVP (Access)


"sjlevine34" <sjlevine34@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DD43975A-2896-4EF1-A6EF-F30534F60B44@xxxxxxxxxxxxxxxx
> 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


.

Relevant Pages

  • Re: MAX NUMBER
    ... i am entering dat in an access front end connect to an oracle database. ... To retrieve the max number in a column of a table, use a query similar to the following: ... adding one to this max number smells suspiciously like one should be using an Oracle Sequence as it will autoincrement an interval based on the last value used. ...
    (comp.databases.oracle.misc)
  • Re: Retrieve size of db objects
    ... given a certain Oracle database, I need to execute queries/commands in ... : order to retrieve the following information: ... The Oracle Reference manual lists all the data dictionary views, ...
    (comp.databases.oracle.server)
  • Capturing returned ODBC error message using form_Error
    ... I have written an application with an Access front end to an Oracle Database. ... user-defined error messages. ... Is there any way I can retrieve this message during ...
    (microsoft.public.access.externaldata)
  • [NEWS] Oracle Database 9ir2 Interval Conversion Buffer Overflow
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Oracle Database Server provides two functions that can be used with PL/SQL ... Exploitation of these vulnerabilities becomes easy if Oracle ...
    (Securiteam)
  • Oracle Database Buffer overflow vulnerabilities in procedure DBMS_DRS.GET_PROPERTY (DB03)
    ... Fayó of Application Security Inc. ... Oracle Database Server provides the DBMS_DRS package that includes ... SYS.DBMS_DRS can exploit this vulnerability. ...
    (Bugtraq)