https://bugs.documentfoundation.org/show_bug.cgi?id=158056
--- Comment #3 from [email protected] --- As you can deduce from my previous exposition, to be able to connect to the database it is required to have installed the data provider "Microsoft.ACE.OLEDB.12.0". The steps to follow to verify that you can establish the connection with the *.mdb files are the following (you can use the attached example database): 1. If you do not have the provider installed, download and install the package "Microsoft Access Database Engine 2010 Redistributable" 2. 2. Open Base to create a new database 3. In the database wizard, select "Connect to an existing database" and in the drop-down list, select "Microsoft Access 2007". Click on "Next2 4. In the second step, click on the "Browse" button. 5. In the text box type "*.mdb" (without the quotes) and press "Enter" to make the file explorer display the *.mdb files. 6. Browse to find and select the *.mdb file and click on the "Open" button. 7. Click on "Finish" and give a name to the .ODB file. An additional check that can be made to find out which data providers are installed is to use the ADO connection (actually, Base uses ADO internally to connect to Access databases): Open Base to create a new database 2. 2. In the database wizard, select "Connect to an existing database" and in the drop-down list, select "ADO". 3. In the second step of the database wizard click on the "Browse" button. 4. A window will appear with a list box with the installed data providers, among them, if we have installed the "Microsoft Access Database Engine 2010 Redistributable", we will have "Microsoft Office 12.0 Access Database Engine OLE DB Provider" which is the one used for the "Microsoft Access 2007" connection. 5. In the unlikely event that you have "Microsoft.Jet.OLEDB.4.0" installed, it will also appear in this list. If you have installed a modern version of Access or have installed the "Microsoft Access Database Engine 2016 Redistributable", you also have the "Microsoft Office 16.0 Access Database Engine OLE DB Provider". -- You are receiving this mail because: You are the assignee for the bug.
