Bug 137252 - Libre Office Base can't open mdb 2000 and mdb 2002/2003 files and problems editing accdb 365 files
Summary: Libre Office Base can't open mdb 2000 and mdb 2002/2003 files and problems ed...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.0.1.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: inReleaseNotes:24.8
Keywords:
Depends on:
Blocks:
 
Reported: 2020-10-05 00:59 UTC by Heine
Modified: 2024-07-16 08:05 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Access 2002/2003 mdb (276.00 KB, application/msaccess)
2020-10-05 01:01 UTC, Heine
Details
Access 2000 mdb (276.00 KB, application/msaccess)
2020-10-05 01:03 UTC, Heine
Details
Access 2007-2016 in fact 365 database (396.00 KB, application/msaccess)
2022-06-01 14:40 UTC, Heine
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Heine 2020-10-05 00:59:27 UTC
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.
Comment 1 Heine 2020-10-05 01:01:23 UTC
Created attachment 166073 [details]
Access 2002/2003 mdb

Sample Access 2002/2003 test database.
Comment 2 Heine 2020-10-05 01:03:35 UTC
Created attachment 166074 [details]
Access 2000 mdb

Sample Access 2000 mdb with data.
Comment 3 Julien Nabet 2020-10-05 18:20:15 UTC
Jean-Pierre: thought you might be interested in this one.
Comment 4 Jean-Pierre Ledure 2020-10-06 08:43:17 UTC
Sorry. I'm not competent at all in debugging or correcting the LibreOffice interface with MSAccess files.

I cannot help in this matter.
Comment 5 Xisco Faulí 2022-05-02 14:00:04 UTC
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.
Comment 6 Heine 2022-06-01 14:17:17 UTC
Fixed
Comment 7 Heine 2022-06-01 14:37:52 UTC
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.
Comment 8 Heine 2022-06-01 14:40:06 UTC
Created attachment 180526 [details]
Access 2007-2016 in fact 365 database
Comment 9 Heine 2022-06-01 14:41:53 UTC
The java UCanAccess driver also works perfectly on Access 2000, 2002-2003 files thru dbeaver community edition.
Comment 10 Julien Nabet 2022-06-01 15:53:23 UTC
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.
Comment 11 Lionel Elie Mamane 2024-07-05 15:09:20 UTC
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
Comment 12 jcsanz 2024-07-05 16:16:44 UTC
(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.
Comment 13 Lionel Elie Mamane 2024-07-05 16:28:30 UTC
(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.