<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Have not been able to access an old MS Access Database file (.mdb) in years using LibreOffice"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107890">107890</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Have not been able to access an old MS Access Database file (.mdb) in years using LibreOffice
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>joe_devore@mailhaven.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
First my bug report/or/Enhancement-request not sure which.. lol
is similar to
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Unable to link Access 2010 database causing LireOffice to freeze and requiring force kill"
href="show_bug.cgi?id=97579">https://bugs.documentfoundation.org/show_bug.cgi?id=97579</a>
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..
<a href="https://forum.openoffice.org/en/forum/viewtopic.php?f=15&t=8872">https://forum.openoffice.org/en/forum/viewtopic.php?f=15&t=8872</a>
<a href="https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=1771">https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=1771</a>
________________________________________________________________________
... 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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>