Err.Description incomplete

[snerting]

Hi!

I have an Access application on top of an Oracle database. There are lots of constraints in this database, both normal relational/unique constraints and also some custom trigger constraints.

I mainly insert/update the data in two different ways
a) myform.Refresh - for the databound controls
b) myrecordset.Update - for other cases

With a) I get fully descriptive error messages from Oracle explaining what the problem really was. With B) I only get "ODBC-call failed".

Anyone knows why the recordsets won't give me the real errors? As they reach Access when doing myform.Refresh, it's apparant that Oracle is attaching the error message like it is supposed to.

 

[PHV]

Have a look at the Errors collection.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886