Start a conversation

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 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.
Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Tyler Kozikowski

  2. Posted
  3. Updated

Comments