KB438505: In Windows 10, users get an error when creating a DSN to Microsoft Access (.accdb) metadata

In Windows 10, when creating a DSN to Microsoft Access (.accdb) metadata using the Strategy Connectivity Wizard, users get the following error:
An error occurred while creating the DSN:Error in Saving the DSN:RegistrySubKeys::OpenSubKey - Key not found

The error happens because the 64-bit Windows 10 system does not come with the 32-bit Access driver. To resolve the error, do the following:

• Download the Access database driver (AccessDatabaseEngine.exe) from http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734. Once you have installed the driver, you will be able to see Microsoft Access driver (*.mdb, *.accdb) as an option in the 32-bit ODBC Administrator.

• Use the 32-bit ODBC Administrator or Strategy Connectivity Wizard to create the DSN to your metadata.The error should no longer occur.

Take the Administration for Enterprise Analytics (10.311) course to learn more about establishing connectivity with the data sources in the Strategy Analytics platform environment.
  KB438505