Share via

Access error "Could not use ; file already in use. (Error 3045)"

Anonymous
2022-02-18T02:12:07+00:00

I am getting the error 'Could not use ; file already in use.' when I try to Compact and Repair any database file. The error occurs when the database is open and I go to Database Tools...Compact and Repair. It also occurs if I close the current database and use Compact and Repair with no file open. It occurs on any drive I select for the destination as well as any drive used for the source file. I am working on local drives only.

I have checked for orphaned *.lccdb files and none exist.

I tried creating a blank database with no objects and then doing the Compact and Repair. The error still occurs.

To eliminate an error in a database I copied one to another PC and the file compacts and subsequently runs with no problem.

I tried doing a repair on Office 365 using both the Quick Repair and the Online Repair option and neither resolved the error.

I last compacted a file yesterday. I checked for updates and patches and none have been installed.

Any ideas are appreciated.

Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2022-02-18T06:36:33+00:00

    Hi David,

    I am glad to assist you.

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

    1. 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.
    2. You may check and confirm that the Access database is not marked as read-only.
    3. Check your file, that should not be scanned or opened in any anti-virus present on your system.
    4. 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/access-database-wont-open-file-already-in-use-not/d0f9ebf4-aed4-42be-87dc-d24735fa0868 

    Thanks

    Suyash Thomson

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-02-18T02:27:42+00:00

    What is you Access build no?

    So you have Grammarly installed on your PC by any chance?

    0 comments