Re: ODBC connection 8.0 won't write to database
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.
Subject
Written By
Posted
September 19, 2018 04:30AM
September 19, 2018 09:10AM
September 24, 2018 02:32AM
Re: ODBC connection 8.0 won't write to database
June 22, 2018 10:22PM
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.