Summary: | Libre Office Base can't open mdb 2000 and mdb 2002/2003 files and problems editing accdb 365 files | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Heine <heine.ferreira> |
Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | normal | CC: | jp, serval2412, xiscofauli |
Priority: | medium | ||
Version: | 7.0.1.2 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: |
Access 2002/2003 mdb
Access 2000 mdb Access 2007-2016 in fact 365 database |
Description
Heine
2020-10-05 00:59:27 UTC
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. |