In a standardinstallation of Microsoft Office there is no driver for ODBC for accdb files installed.
To support thoose files you need to install the MS Access Database Engine 2016.
Environment:
QV Desktop all versions
Office 2016 tested
Office 2016 does not install the ODBC drivers for accdb files per automatic.
Download the
Microsoft Access Database Engine 2016 Redistributable
https://www.microsoft.com/en-us/download/details.aspx?id=54920in case you get an error in the install saying that the "Office 16 Click-to-Run Extensibility Component 64-bit Registration prevents Office 32-bit installation" then follow the steps described in the article below
to uninstall Office 16 Click-to-Run Extensibility Component 64-bit/32bit Registration, please try the steps below:
- Press Win + R to open the Run window, type “installer” and click Enter to open the folder in File Explorer.
- Add the column “Subject”. Right click the column headers, then click More and select Subject
- Sort on the Subject column and scroll down until you locate the name “Office 16 Click-to-Run Extensibility Component 64-bit Registration”.
- Right click the MSI file and choose uninstall.
- scroll down until you locate the name “Office 16 Click-to-Run Extensibility Component Registration” - 32 bit
- Right click the MSI file and choose uninstall.