Description: If you try to edit an MS Access table using LO Base and an ODBC connection you get an error message saying the the bookmark is invalid. Steps to Reproduce: Use LO Base to connect via ODBC to an MS Access .accdb file using the Microsoft Access Driver version 16.000.15028.20050 ACEODBC.DLL Edit a record and then move off the record to commit the edit. Please watch this YouTube video: https://youtu.be/M_hqZegXcXM Actual Results: Error message blocking the edit of the record Expected Results: Record is edited Reproducible: Always User Profile Reset: Yes Additional Info: Please watch this video to see how to reproduce the bug: https://youtu.be/M_hqZegXcXM
Created attachment 179306 [details] Error message when editing an MS Access record using LO Base via ODBC
Have no Access and Windows here, but are you sure it is a bug of Base? I have searched for 'Access "not a valid bookmark"' and get many results. Some try to repair the database through ODBC-GUI, some says the file is corrupted …
MS Access ODBC driver is a very solid drive and I suspect it is a bug in Base. This is not a corruption issue with the MS Access database. This bug I believe is related to the other bug I filed: https://bugs.documentfoundation.org/show_bug.cgi?id=148343 You can replicate bug 148343 with Ubuntu. No need for Windows.
I confirm with 64-bit LO 7.4+ in 64 Win 7 with 64-bit Access Database Engine 2016. Should also be tested with 32-bit. Problem is that ODBC has this error and MS Access driver read-only bug 43187 so not usable at all.
Problem didn't exist with 32-bit Access Database Engine and LO. I set High because now 64-bit is usually used and users may not even think of 32/64 issue. Also because this shouldn't be a large problem. And because direct access also doesn't work so Access database not usable but relatively frequent.