Forum Discussion
Gateway Locks Acces-files
Hello everyone,
I hope someone can help us with the following problem:
We are getting the following error message when trying to synchronise Power BI Online:
Error: -2147467259
Errormessage: Could not use 'Minas.accdb'; file already in use.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Detail: Minas.accdb
Microsoft.Data.Mashup.ValueError.Reason: DataFormat.Error
URI cluster: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
Time: 2021-12-15 09:55:07Z
We use the following:
- Windows server 2012 R2 Standard
- On-premises data gateway (3000.106.11 (November 2021))
- Microsoft Access database engine 2016 (English)
Our problem is that the on-premises data gateway locks the Acces-files. To unlock those files, the service needs to be stopped, then all the gateway processes need to be stopped on the server and then the service needs to start again. After the gateway unlocks the files, we can acces the files again. Unfortunately, if we synchronise again online, the gateway locks the files again and shows the errormessage given above.
Can anyone help us with this problem?
Kind regards,
Jennifer
Problem solved when u update the driver:
Can't install the newest update yet but i will try it monday again.
Greatings, DMS
2 Replies
- lbendlin
Super User
Unfotunately that's how Access works. Use a different database as your data source.
- DMSJennifer
Helper I
Problem solved when u update the driver:
Can't install the newest update yet but i will try it monday again.
Greatings, DMS