January 17, 2024
Hello,
I have a PQ that references files in a folder in OneDrive.
If the source files in the folder are closed, the query refreshes quickly and properly.
However, if one of the source files are open, I receive the following error:
The Microsoft access database engine cannot open or write to the file It is already opened exclusively by another user or you need permission to view and write its data.
Users will have to have the source files open, so I need to figure out how to resolve this error.
Thank you!
Trusted Members
Moderators
November 1, 2018
January 17, 2024
The PQ loops through files in a folder. Users add cases to their files and the main PQ then gets updated. I am surprised we can't have files open to refresh the main PQ.
The users folder is in OneDrive. Are you saying they should be placed in SharePoint?
Also, what if they are on a shared network drive, as opposed to OD or SP?
Thank you!
1 Guest(s)