Dao Exception 3146- “ODBC Failed “

Hi,

In my program I sometimes connect to ODBC databases using DAO.

At times I try to do operations that will cause an exception, like try to add a record that cause a duplicate primary key.

The problem is that all the information DAO gives me is “ODBC – Failed” (when trapping DaoExceptions)

I noticed that when using ODBC I can get a real useful error message (like: “Violation of PRIMARY KEY constraint 'UPKCL_auidind': Attempt to insert duplicate key in object 'authors'.")

Is there a way to get this error message when using DAO?

Thanks,

Eli