Bug 107360 - No Access connection for 64 bit LO (Windows) - see Comment 7
Summary: No Access connection for 64 bit LO (Windows) - see Comment 7
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.3.4.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-04-23 06:38 UTC by Leif Johansen
Modified: 2017-10-21 07:30 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Screen dump of error in Base (6.47 KB, image/png)
2017-04-23 06:42 UTC, Leif Johansen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Leif Johansen 2017-04-23 06:38:48 UTC

    
Comment 1 Leif Johansen 2017-04-23 06:42:58 UTC
Created attachment 132761 [details]
Screen dump of error in Base

For a year ago I have made a connection to a accdb or mdb file. To day it is not possible

I got the error you can see at the
Comment 2 Alex Thurgood 2017-04-24 08:32:51 UTC
@Leif : please provide the version of Windows and bit (32 or 64) version of LibreOffice that you are using.
Comment 3 Leif Johansen 2017-04-24 09:21:27 UTC
I use Windows 10 64 bit Home version. 
I have Libre Office  64 version

PC is old - very old but still going strong
Comment 4 he-lang 2017-07-21 16:00:26 UTC
I have the same problem.
After the update to 5.3, no MS Access database can be opened with LO.
Error message:
The connection could not be established. The required data provider may not be installed.
System Win 7 Pro 64Bit , Libre Office 5.3.4.2 64Bit
Comment 5 Timur 2017-07-21 16:17:16 UTC
Please also add which driver you're using. Like in 
https://bugs.documentfoundation.org/show_bug.cgi?id=43187#c14
Comment 6 robert 2017-07-23 06:49:26 UTC
Isn't MS-Access a 32bit Software? Could it be LO 32bit will solve this problem?
Comment 7 Thomas Krumbein 2017-10-11 07:32:09 UTC
Additional informations regarding this bug:

all Windows 64 bit versions of LO do not support access 2007 *.mdb databases any more. You will get every time the provided error-message.

Even it is not possible to create an ODBC access to those databases via MS Windows system in 64 bit environment. Only 32bit environment is supported. 

But when you have installt a 64 bit LO on a 64 bit Windows system (with makes sense;)) - you cannot access the 32 drivers. 

So: two suggestions:

1.) Remove the support for Access 2007 (*.mdb) from all 64 bit MS Windows compilations  - so no user will run in trouble.

2.) Rework the filter - but I guess, this is not an easy task;)


For all users:  Install LO 32 bit and you will have access to *.mdb databases. 

Create then a new base-document (tested with hsqldb) - drag&drop the tables from mdb-file to hsqldb file (you have to add typicly a unic-key field and you have to rearrange the columns data-width). This base document with all your datas will now work even in 64bit environment.
Comment 8 Alex Thurgood 2017-10-20 13:48:44 UTC
(In reply to Thomas Krumbein from comment #7)
> Additional informations regarding this bug:
> 
> all Windows 64 bit versions of LO do not support access 2007 *.mdb databases
> any more. You will get every time the provided error-message.


Indeed, this is also mentioned on the MSDN forums. According to the posts there, there is no Microsoft supported way to access a 32bit MDB file using a 64bit program. As LO relies on Microsofts own drivers to do this, Access97 and Access2003 files are no longer accessible with 64bit LO. 


> 
> Even it is not possible to create an ODBC access to those databases via MS
> Windows system in 64 bit environment. Only 32bit environment is supported. 
>

You can however use ODBC on 64bit Windows installations to 64bit accdb files, see comment 13 of bug 104757.
Comment 9 Alex Thurgood 2017-10-20 13:50:46 UTC
I suggest closing this, and other similar reports as either WONTFIX, or NOTOURBUG, or else WFM in 64bit everything and Access >= 2010.
Comment 10 eremmel 2017-10-21 07:30:23 UTC
Access to *.mdb files with LO x64 is possible via ODBC and installing Microsoft Access Database Engine 2016 Redistributable.
Verified against LO 5.4.2.2 (x64)