Forum Discussion
Helper IGateway 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
1 Reply
Hi DMSJennifer ,
Please have a try.
If the access database is shared on network with \\<server name>\users\<user name>\...? If so, please band aided the issue by unticking 'Enable parallel loading of tables' in Options --> Current File, Data Load.Obviously this makes the query refresh take slightly longer but removes the annoyance of individually refreshing tables.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
