https://bugs.documentfoundation.org/show_bug.cgi?id=107890
Bug ID: 107890
Summary: Have not been able to access an old MS Access Database
file (.mdb) in years using LibreOffice
Product: LibreOffice
Version: 5.3.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: joe_dev...@mailhaven.com
Description:
First my bug report/or/Enhancement-request not sure which.. lol
is similar to
https://bugs.documentfoundation.org/show_bug.cgi?id=97579
so I though I would reference it... :/
I have an old Microsoft Access Database file (.mdb) I have not been able to
access for a few years or more... I no longer have the old MS Office 2003 or
was it 2007 I cannot recall anymore since last time the server was up and
running was 2011... and I was able to access it using I think Open Office and
then LibreOffice after the move over to it... but not in a long time...
an excerpt from the header of the .mdb file
- Standard Jet DB
- 4.0
That's all there was for readable text from the head of the file.
here are some Google search results I found on this subject..
https://forum.openoffice.org/en/forum/viewtopic.php?f=15&t=8872
https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=1771
________________________________________________________________________
... when I try to re-setup this using "connect to an existing database"
and I select "Microsoft Access" and the mdb file.. it seems to go fine...
it saves an odb file for opening/connecting-to the mdb.. but I get the
following 2 errors when I try to access the tables:
- The connection to the data source "database-name" could not be established.
- "SQL Status: HY000
The connection could not be created. May be the necessary data provider is not
installed."
Steps to Reproduce:
1. open LibreOffice - base
2. "connect to an existing database"
3. select "Microsoft Access"
4. select .mdb file (Standard Jet DB 4.0)
5. save the .odb file
6. open the .odb file to read the .mdb file
7. click on tables and get error listed in description.
Actual Results:
get error listed in description.
Expected Results:
open .odb file to read .mdb file and read tables successfully..
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:53.0) Gecko/20100101
Firefox/53.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
