Forum Discussion
Solved
Access 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
You have the access database open, and the lock file is confused. Either close Access or reset the lock file.
Is there a good way to query that data if that file is almost always in use?
A better way would be to have the data in a proper database, not something that is file based.
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!
