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.
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

Please also add which driver you're using. Like in 
https://bugs.documentfoundation.org/show_bug.cgi?id=43187#c14

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 5.4.2.2 (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?
Chris

(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
> 




https://www.microsoft.com/en-us/download/details.aspx?id=54920

Sorry, first post was an incorrect link (typed instead of pasted)

Tried in LO 5.3.4.2  "The connection could not be created"- error message appeared. In previous version LO 5.2.5.1 and next LO 5.3.7.2  connections was created, but not editable.

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?

Thank you
Bernard

https://bugs.documentfoundation.org/show_bug.cgi?id=97395#c35
https://bugs.documentfoundation.org/show_bug.cgi?id=97579#c20

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
Engine 2016:
Module de compatibilité pour Microsoft Office System 2007, Microsoft
Office PowerPoint Viewer 2007 (French), Visionneuse Microsoft
PowerPoint

Not sure there is a 64-bit version of PowerPoint Viewer... :-)

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...