MySQL Forums
Forum List  »  Connector/ODBC

Re: ODBC connection 8.0 won't write to database
Posted by: David Webb
Date: June 22, 2018 10:22PM

Bogdan, I can confirm this is also a problem for the following setup:

Microsoft Access 64-bit connecting via ODBC 64-bit Unicode 8.0.11 to MySQL 8.0.11. Using an ADODB.Recordset in Access VBA, opened using adOpenForwardOnly (the default) and adLockOptimistic.

I can add new records but I cannot update existing records. If I change the CursorType to adOpenKeyset, then update works.

Options: ReplyQuote

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.