Forum Discussion
DemingPDCA
Helper II
Helper IIAccess Database Connection - Unable to Connect, File already in Use
Anyone seen anything like this before when trying to get PowerBI to connect to an access database? "We encountered an error while trying to connect. Details: "Count note use"; file already in use"
You have the access database open, and the lock file is confused. Either close Access or reset the lock file.
8 Replies
- lbendlin
Super User
You have the access database open, and the lock file is confused. Either close Access or reset the lock file.
DemingPDCAIs there a good way to query that data if that file is almost always in use?
- lbendlin
A better way would be to have the data in a proper database, not something that is file based.
- DemingPDCA
Yeah - that's what I was afraid of :-\... Unforunately this is one of these old old access databases built years ago that everyone is afraid to touch 🙂 Thanks for your help!