Forum Discussion
Access Database file interrupts the refresh every day because the "file is in use when it isn't
Yes, it does look like refreshing tables in parallel locks the Access file, as discussed in this thread:
The thread above gives a solution for Power BI Desktop, but I'm not sure you could enforce serial refreshing in the gateway settings. A couple of workarounds come to mind:
1. Create three separate dataflows for your three Access tables and orchestrate their serial refreshing via Power Automate. This would be my initial attempt if I had to quickly solve the issue myself.
2. Use the Dataverse connector in Access so that Dataverse is your source for Power BI. This is probably what I'd pursue if I had time and wanted to get other benefits of the Power Platform and/or start thinking about eventually migrating everything to the cloud.
Hi WorkHard ,
According to my knowledge, the error is caused by the Access file.
Know the cause of ‘Access database already in use’ error
1.Damaged Access database file/corruption in Access database file
2.User does not have ‘create’ rights for the folder in which the database is present, and he opens the database. The MS Jet database engine does not create the locking information file (LDB in Access 2003 and in earlier Access versions and LACCDB in MS Access 2007 and 2010 versions, which is essential for multiple users to open the database.
For more details, please refer to:
Resolving Access database error ‘file already in use’
Error in Access when opening a database on a network file share
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.