https://bugs.documentfoundation.org/show_bug.cgi?id=158056
--- Comment #4 from [email protected] --- Summary of current status * Currently to connect to MS Access .mdb files you need the "Microsoft.Jet.OLEDB.4.0" provider. * The "Microsoft.Jet.OLEDB.4.0" provider needs to be installed on the computer to use it. * The connector "Microsoft.Jet.OLEDB.4.0" is not available on the Microsoft download pages for some time now * You can connect to both .mdb and more modern .accdb files via the "Microsoft.ACE.OLEDB.12.0" provider, but Base is only prepared to use this provider with .accdb files. * The "Microsoft.ACE.OLEDB.12.0" provider also needs to be installed, but it is still possible to download an installer from the Microsoft pages. Proposed solution * Modify the code so that all connections to MS Access files, both .mdb and .accdb are made with the provider "Microsoft.ACE.OLEDB.12.0". * Remove all references to the "Microsoft.Jet.OLEDB.4.0" provider to clean up the code. * Leave only one entry "Microsoft Access" in the Connection Wizard, which would work for .mdb and .accdb files. * Remove the entry "Microsoft Access 2007" from the Connection Wizard, since it is no longer needed. -- You are receiving this mail because: You are the assignee for the bug.
