Unable to create gateway connection for Access database using ODBC connection type

Question

Hello All,&nbsp;Using connection string ODBC Microsoft Access database as a datasource in Power BI desktop, I was connected and built a report. I have published the report into Power BI service to collaberate with others. While creating gateway connection for ODBC data sorce type using connection string but unable to create it and getting below error message.&nbsp;ODBC: ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x33b8 Thread 0x68fc DBC 0x3a9a05c8 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x33b8 Thread 0x68fc DBC 0x3a9a05c8 Jet'. ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine cannot open or write to the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view and write its data. ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x33b8 Thread 0x68fc DBC 0x3a9a05c8 Jet'. ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x33b8 Thread 0x68fc DBC 0x3a9a05c8 Jet'. ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine cannot open or write to the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view and write its data.&nbsp;Also i was able to connect it in power BI desktop on gateway machine where On-premises data gateway is installed.&nbsp;&nbsp;Below is the connection string i am using in both Desktop and Service.&nbsp;driver={Microsoft Access Driver (*.mdb, *.accdb)};dbq=\LAN Folder\Ynr_be.accdb.&nbsp;Can anyone please help me on this to create the gateway connection for ODBC access database.Thanks in advance!

ynr225 · Answer

Thanks for responding&nbsp;GilbertQ&nbsp;, I checked from my side and confirmed that no one has opened Access database. Again i tried to create the gateway but no luck. I can see the same error.&nbsp;&nbsp;

ynr225 · Answer

Hi&nbsp;GilbertQ&nbsp;,&nbsp;&nbsp;I tried the above method but no luck still i am receiving the same error message in Power BI service.&nbsp;&nbsp;

ynr225 · Answer

Hello&nbsp;GilbertQ&nbsp;,I have lot of network drives and I was moved file to one of the network location and was able to create the gateway connection. But the user don't have access to that network drive and can't provide access because it was another team member network drive. I have checked the permissions as both of drives have read only access to the access database files.&nbsp;

gilbertq · Answer

Hi&nbsp;Ynr225&nbsp;
&nbsp;
Based on the error above what it is saying is that the Access is already open. And what that means is you need to close the file. So that is not open and being used by anyone, or it can be read via the Gateway.

gilbertq · Answer

Hi&nbsp;Ynr225&nbsp;
&nbsp;
Could I ask you to please try and move the access database to a new location and see if that fixes it?

Forum Discussion

Unable to create gateway connection for Access database using ODBC connection type

8 Replies

Related content

Database connectivity.

Notebook connect to Fabric SQL Database

Connection failed using a Folder connection in a pipeline

Power BI Oracle Connection Error – ORA-50201 (Failed to connect / parse connect string)

connection to dataflows