MySQL Forums
Forum List  »  Microsoft Access

Re: Access form ODBC error using "GET DIAGNOSTICS"
Posted by: Andrew Betteridge
Date: December 16, 2015 07:15AM

This does work actually if you run a both failed query and then "SHOW ERRORS;" using the same database object in VBA.

But it doesn't return anything when you run a failed update on a form and then try "SHOW ERRORS;" in VBA.

I guess because the form uses a different database object to the one created in VBA the "SHOW ERRORS;" runs in a completely different context.

Does anyone know if "SHOW ERRORS;" is connection specific?

Is there anyway to hijack the Access form's connection to display "SHOW ERRORS;" for it specifically?

Options: ReplyQuote

Written By
Re: Access form ODBC error using "GET DIAGNOSTICS"
December 16, 2015 07:15AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.