Forum Discussion

EasyOrImpossible's avatar
EasyOrImpossible
Copper Contributor
Feb 21, 2022
Solved

Strange problem compacting Access databases

My installation of MS Access (Office 365 subscription) suddenly lost the ability to compact and repair databases, after more than two years of working fine.  I always get the error "Could not use [db...
access
  • George_Hepworth's avatar
    George_Hepworth
    Mar 08, 2022
    Some people have reported that this problem lingers IF they also have MacAfee Anti-Virus installed. Try disabling it to see if that corrects the problem. Also, see if you can white-list Access in the MacaFee AV if that is the case.
suyashthomson's avatar
suyashthomson
Copper Contributor
Feb 24, 2022

Hello EasyOrImpossible,

I am glad to assist you.

You may operate some ordinary checks. Here are the things you must check before using the compact and repair method or any online repair tool.

 

  • All users running this MS Access have the privilege where the MDB file in the directory exists. If JET cannot create an LDB file when logging into a database it will generate a 3045 error.
  • You may check and confirm that the Access database is not marked as read-only.
  • Check your file, that should not be scanned or opened in any anti-virus present on your system.
  • Check your code to make it clear that you are not doing an explicit Close to the thing opened on your system and setting object variables to nothing as soon as you are done with something.

Check out this thread as well, if this could help your issue somewhere:

 

https://answers.microsoft.com/en-us/msoffice/forum/all/err-3045-impossible-to-use-nameddb-file-in-use/ae0581f3-bd2c-43f9-bf95-47628f665c31

 

Thanks,

SuyashThomson

Resources