Windows 10 
Access 2016
Out of nowhere I am getting Error 3045
“Could not use MyData.mdb – file already in use”
This system has been running for over 20 years, though the code is being updated regularly.
The current version is Access 2016. MyData.mdb resides on a server.
Identical copies of the code MyCode.accdb are copied to two PC’s A & B at the start of day and activated. MyCode links to the MyData which stays on the server. Up until this week A & B could both operate independently with no issues.
Staring a few days ago A loads up and operates, but B gets the 3045 message. If A closes the application then B can operate.
The permissions of MyData have not changed – “Everyone” has full access.
I have done several Compact and Repair’s. I have used Task Manager to close down almost every other application to ensure no “third application” is interfering.
I rolled back the code version to a level that previously worked, but the error persisted (so not a recent code change). There have been some recent Windows updates, but these happened after this issue started and were only allowed in whilst doing reboots – the systems are normally switched on 24x7 with updates not allowed.
I have searched the Internet and followed all the advice there – which mostly relates to people getting this error during early development, when things have not yet worked – this system has been working for decades.
Last gasp might be to purchase a Repair Tool – but I don’t want to go down the paid route until I understand the problem better.
So any ideas please?????
Reply With Quote
Originally Posted by Ajax
