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 220.127.116.11 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 18.104.22.168 (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 22.214.171.124 "The connection could not be created"- error message appeared. In previous version LO 126.96.36.199 and next LO 188.8.131.52 connections was created, but not editable.
This article gives the info, go on http://windowstuts.net/connections
if you want to take more information regarding Bluetooth connectivity then apply and follow steps which i provided you.
I understood that the solution is:
- either use an ODBC connection after MDAC installation,
- or retrograde to LibreOffice.32-bit
But I didn't understand where the problem is located:
- MS-Access databases (*.mdb) are no longer supported by Windows 64-bit
- or is it the LibreOffice 64-bit connection to these files that no longer works?
This is a bot that naturally changes over LaTeX presents and remarks on Images. It's a work in advancement. Answer with !latexbotinfo for points of interest and https://www.assignmentdone.co.uk. In the event that you think this bot is passing up a great opportunity a significant subreddit, if you don't mind send me a PM.
I guess it's safe enough to close as NOtOurBug.
From what I see, we don't have documentation on all this and should be there.
To connect to my Access database I tried to install MDAC 64-bit but:
You cannnot install the 64-bit version of Microsoft Access Database
Engine 2016 because you currently have 32-bit Office products
installed. If you want to install 64-bit Microsoft Access Database
Engine 2016, you will first need to remove the 32-bit installation of
Office products. After uninstalling the following product(s), rerun
setup in order to install 64-bit version of Microsoft Access Database
Module de compatibilité pour Microsoft Office System 2007, Microsoft
Office PowerPoint Viewer 2007 (French), Visionneuse Microsoft
Not sure there is a 64-bit version of PowerPoint Viewer... :-)
If you're not ready to go home. Can I get a hell no, cause we gonna go all night. Till we see the sunlight alright http://happy-wheelsgames.com happy wheels http://happy-wheelsgames.com/basketball-legends-game basketball legends game
Downloading WhatsApp Status Videos from youtube is a hard task like you have to copy URL first and then paste in a youtube downloading website. I have a solution to this problem, I have created a new website for latest status videos check it out
Great article with excellent idea!Thank you for such a valuable article. I really appreciate for this great information: https://www.weddinganniversarywishesmessages.com
As everyone knows quite well, this Christmas is the birthday of Lord Jesus. And now we celebrate Christmas each year on 25th of December. And then Jesus spent his entire life to provide us the exact message of humankind. So, I believed we have to spread love, happiness, and humankind everywhere, where people go. If you are looking for the very best assortment of Christmas 2018 images , Christmas wallpaper along with christmas pictures of 2018 your hunting is finished nowhere this article you’ll secure the ideal assortment of https://www.merrychristmashappynewyear2018.com/2017/10/merry-christmas-day-shayari-text-messages-sms-hindi.html Christmas Shayari 2018.
I'm removing everyone from this bug as it's constantly under spam attack.
@Leif, if you still reproduce this issue in the latest version of LibreOffice, prease, create a new report. Sorry for the inconveniences...
This is a blog you can find better stuff right here
<a href="http://taylor411.com/why-use-reloadable-prepaid-cards-here-are-some-amazing-reasons/">reloadable prepaid cards/<a>
make sure you can check it out
very nice site.you can download the status videos from this site.