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
@Leif : please provide the version of Windows and bit (32 or 64) version of LibreOffice that you are using.
I use Windows 10 64 bit Home version.
I have Libre Office 64 version
PC is old - very old but still going strong
I have the same problem.
After the update to 5.3, no MS Access database can be opened with LO.
The connection could not be established. The required data provider may not be installed.
System Win 7 Pro 64Bit , Libre Office 18.104.22.168 64Bit
Please also add which driver you're using. Like in
Isn't MS-Access a 32bit Software? Could it be LO 32bit will solve this problem?
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.
(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.
I suggest closing this, and other similar reports as either WONTFIX, or NOTOURBUG, or else WFM in 64bit everything and Access >= 2010.
Access to *.mdb files with LO x64 is possible via ODBC and installing Microsoft Access Database Engine 2016 Redistributable.
Verified against LO 22.214.171.124 (x64)
It has been suggested that the answer is to back-grade LO to a 32 bit version. Fine, but my experience over the last few years is that, as soon as an upgrade is available, Base 'stops responding', so this seems unlikely to work. I wish I knew why this happened as it seems illogical, but that has been what has happened to me.
The other suggestion is that to download 'Microsoft Access Database Engine 2016 Redistributable' will make access possible. I have been unable to find any way of doing this. Advice?
(In reply to Chris Grove from comment #11)
> The other suggestion is that to download 'Microsoft Access Database Engine
> 2016 Redistributable' will make access possible. I have been unable to find
> any way of doing this. Advice?
(In reply to Alex Thurgood from comment #12)
> (In reply to Chris Grove from comment #11)
> > The other suggestion is that to download 'Microsoft Access Database Engine
> > 2016 Redistributable' will make access possible. I have been unable to find
> > any way of doing this. Advice?
> > Chris
Sorry, first post was an incorrect link (typed instead of pasted)
Tried in LO 126.96.36.199 "The connection could not be created"- error message appeared. In previous version LO 188.8.131.52 and next LO 184.108.40.206 connections was created, but not editable.