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

[Ynr225]

Hello All,

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.

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.

Also i was able to connect it in power BI desktop on gateway machine where On-premises data gateway is installed. 

Below is the connection string i am using in both Desktop and Service.

driver={Microsoft Access Driver (*.mdb, *.accdb)};dbq=\\LAN Folder\Ynr_be.accdb.

Can anyone please help me on this to create the gateway connection for ODBC access database.

Thanks in advance!

[GilbertQ]

Hi @Ynr225 

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.

[Ynr225]

Thanks for responding @GilbertQ , 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.

[GilbertQ]

Hi @Ynr225 

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

[Ynr225]

Hi @GilbertQ , 

I tried the above method but no luck still i am receiving the same error message in Power BI service.

[GilbertQ]

Hi @Ynr225 

Could you check and make sure that the same user who is refreshing via the Gateway also has the same permssions to the Access File?

Also maybe the Service account running for the Gateway needs to have additional permissions to the Access file?

[Ynr225]

Hello @GilbertQ ,

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.

[GilbertQ]

Hi @Ynr225 

One last thing can you confirm that you have got access 64 bit installed?

[Ynr225]

Yes i got access 64 bit version installed in my machine. FYI below is the screenshot.