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.
- 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).
- Open the Windows Registry Editor (Regedit) to edit this new DSN to point to your network drive.
- Navigate to "Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INI" and locate your DSN Name.
- Select the DSN and then double click the DBQ key on right hand side.
- Change the Value data from your old path to the new Database path on the network drive IE M:\TracerPlus Data\Asset Demo.accdb.
- Click OK to save and then close the Registry editor.
- Your DSN should now be pointing to the network location.