Dec 31 2021 09:58 PM
Dec 31 2021 09:58 PM
Hi, I'm receiving a "File in use" error when running a macro containing an update query. The message says that the database (mdb) which contains the table that is being updated is busy. The update macro/query is in a "front end" database, and the table is in a "back end" database and linked. I've been running that same macro for years without this happening, so I'm guessing that it may be due to Access not closing down properly at some stage recently and leaving the status of this table as "still in use".
Has anyone else experience this problem and worked out a solution? I'd be grateful to hear about it.
Jan 01 2022 09:38 AM
Many thousand Access users have had this message in the last 3 weeks as it is the most common problem since the security updates of Dec 14. Since then it has also been the most discussed in all Access forums of the world including this one. So, you can read several discussions here for details.
First, have a look at the support article and control if there is a fix for your version of Access.
Jan 01 2022 12:09 PM
Jan 01 2022 12:53 PM
The build you mention is not in the lists of the article. So, it's hard to say if it should have been fixed. In many cases even after installing the currently available fixes there are still problems with network paths. Microsoft is working on further fixes but it's not yet clear when they will be available and if they will fix every version of these problems.
Concerning a temporary downgrade:
Only you (or an admin) knows the circumstances of your usage, needs, security or compliance requirements. In theory you run the risk of a security hole, although Microsoft considers the exploitation unlikely. However, that's always a judgment call with security stories. You can find details about it, if you search with the KB numbers in the support article.
In the end you have to decide if you can wait and see if and when Microsoft fixes the problems or if it is more important for you that your Access application is working properly in the meantime. In case you want to downgrade I've already posted some how-to links in the discussions here, and Daniel Pineault also has them in his blog article.
Jan 01 2022 01:11 PM