Access connection string
I am trying to connect an Access database I have in OneDrive to Azure Data Factory so I can copy it to my Data WareHouse. I have created a Self-Hosted integration runtime environment. However, when I try to connect my database I am not able to give it the correct connection string: I have tried with: Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=https://onedrive.com/path_for_your_database.accdb; I always get a failure and the last one I got is: ERROR [HY000] [Microsoft][Microsoft Access ODBC Driver]General error Cannot open registry key 'Temporary (volatile) Ace DSN for process XXXXX'. ERROR [IM006] [Microsoft] [ODBC Driver Manager] SQLSetConnectAttr Driver Error ERROR [HY000] [Microsoft][Microsoft Access ODBC Driver]General error Cannot open key 'Temporary (volatile) Ace DSN for process XXXXX' in the Registry. ERROR [HY000] [Microsoft][Microsoft Access ODBC Driver] Microsoft Access database engine cannot open or write to the '(unknown)' file. Another user has already opened it exclusively or needs permission to view and write data. Could someone help me to know how to create the correct connection string when hosted in a shared folder on one drive?