[Libreoffice-bugs] [Bug 107890] New: Have not been able to access an old MS Access Database file (.mdb) in years using LibreOffice

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: joe_devore at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170516/2209da7a/attachment-0001.html>