Description: Access ACCDB files saved as MDB files won't open in Libre Office Base. Steps to Reproduce: Take an Access 365 database and save it as an Access 2002/2003 mdb database or an Access 2000 mdb database. Take the new mdb databases and try to open them in Libre Office base using the "Access" driver. It crashes when you click on finish. The original Access 365 accdb database does open with the Access 2007 driver. The mdb database contains only one table with 3 records. There is one autoinc field as the first field and the second field is a text field. For simplicity sake I just captured 3 peoples names into the 3 records with the text field. Actual Results: Libre Office Base crashes when you click on finish. Expected Results: Libre Office Base is suppose to open the database and display it. Reproducible: Always User Profile Reset: No Additional Info: Latest version of office 365. Latest version of windows 10 64 bit prof. Latest Libre Office for windows. I am attaching the mdb 2002/2003 file and the mdb 2000 file. Both won't open. They open perfectly in Access 365. I also tried other tools. Both files open perfectly in MDB Viewer Plus and DBeaver. MDB Viewer is a freeware tool and DBeaver is an open source tool. DBeaver does however prompt you to install the access drivers and it only opens the files once the drivers are installed.
Created attachment 166073 [details] Access 2002/2003 mdb Sample Access 2002/2003 test database.
Created attachment 166074 [details] Access 2000 mdb Sample Access 2000 mdb with data.
Jean-Pierre: thought you might be interested in this one.
Sorry. I'm not competent at all in debugging or correcting the LibreOffice interface with MSAccess files. I cannot help in this matter.
A new major release of LibreOffice is available since this bug was reported. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Fixed
I made a mistake. The bug is still there. Access 2000,2002-2003. You can open it with ADO and ODBC drivers but NOT Access driver. It gives the error message "data provider perhaps not installed". odbc driver: Only viewing possible. When editing it gives the error message "not a valid bookmark". ado: Full viewing and editing possible. Access 365 database with Access 2007 driver: Only viewing of data possible, no editing. Access 365 database with latest Access ODBC driver: Only viewing possible. Trying to edit data gives error "not a valid bookmark". Access 365 database with ADO. Only viewing possible. Doesn't give any error message when trying to edit data. It just doesn't allow you to edit data. The 2007-2016 database attached is in fact an access 365 database. I don't know how to test the java driver but I can tell you that the product dbeaver community edition uses java driver UCanAccess and that does work.
Created attachment 180526 [details] Access 2007-2016 in fact 365 database
The java UCanAccess driver also works perfectly on Access 2000, 2002-2003 files thru dbeaver community edition.
So you reproduced this on 7.3.3.2. Version field is the earliest affected, so don't update this field with a more recent LO version.
Is this maybe fixed with the commit that fixed tdf#158056? https://gerrit.libreoffice.org/165756 https://git.libreoffice.org/core/commit/7edca7dc740f6877fa85c2a996ca869c6b971a48 tdf#158056 Connect to MS Access .mdb files by mean of ACE.OLEDB.12.0 provider
(In reply to Lionel Elie Mamane from comment #11) > Is this maybe fixed with the commit that fixed tdf#158056? > Yes, this is fixed as it is related only to *.mdb files.
(In reply to jcsanz from comment #12) > Yes, this is fixed as it is related only to *.mdb files. Then let's close the bug.