Using an ODBC Datasource for MS Access on a Mapped Network Drive

There is an issue in Windows 10 where you are unable to point an ODBC Datasource to an Access Database on a Mapped Network Drive. Follow the steps below to create the data source on the local drive and edit the registry pointing it to a mapped network drive. 

1. Under ODBC Administrator (32 Bit), Create a new System DSN for the Access database pointing to a local copy of the database (on the C drive somewhere).
2. Open the Windows Registry Editor (Regedit) to edit this new DSN to point to your network drive.
3. Navigate to "Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INI" and locate your DSN Name.
4. Select the DSN and then double click the DBQ key on the right-hand side.
5. Change the Value data from your old path to the new Database path on the network drive IE M:\TracerPlus Data\Asset Demo.accdb.
6. Click OK to save and then close the Registry editor.
7. Your DSN should now be pointing to the network location.