Access version 2201 problem with laccdb

Anonymous
2022-01-31T10:47:34+00:00

Hi!

I have a problem when closing Access program since Access version 2201 (26th January 2022).

There is still a "record-locking informations" laccdb not closing (and that results in several other errors as well like accdb is not opening again and others.

I had to go back to version 2112 ... and then all is fine again.

Is this a wellknown problem with version 2201 already? .... and will this be fixed in a next version?

Thanks for answers

G.

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
Anonymous
2022-02-03T13:08:26+00:00

Most valuable professional. It just means MS recognizes that an individual as contributing to the community. Basically, I help in forums a lot, answer lots of questions, have a very extensive website with lots of information... try to help other users freely. I do not work for MS! I am not paid by MS! I simply try to help fellow users when I can.

Was this answer helpful?

3 people found this answer helpful.
0 comments

49 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-02-05T10:33:05+00:00

    Adding to folder containing the databases to the Trusted Locations solved the problem for me. No error 3048 anymore, no hanging MSACCESS.exe process after closing Access.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2022-02-02T19:46:17+00:00

    Here is a good description provided by Microsoft, how to revert back. Sounds more complicated than it actually is.

    https://support.microsoft.com/en-us/topic/how-to-revert-to-an-earlier-version-of-office-2bd5c457-a917-d57e-35a1-f709e3dda841

    This is the content of my Config.xml to go back to Version 2111, Build 14701.20226. You need to have the right string for the target version you would like to revert to:

    <Configuration>

    <Updates Enabled="TRUE" TargetVersion="16.0.14701.20226" />

    </Configuration>

    Best regards

    Sascha Debie

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2022-02-02T15:55:22+00:00

    I have the same issue and would like to add, that Access 2201 (Build 14827.20158) opens more connections compared to previous version and does not free those* after closing the affected elements. This also results in Access 2201, keeping table IDs open in the background which then leads eventually to error code 3048 "Cannot open any more databases".

    *(at least not all of them)

    We also reverted back, in our case to Access 2111 (TargetVersion="16.0.14701.20226") which does not have the described issue.

    Best regards

    Sascha Debie

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  4. Anonymous
    2022-01-31T11:32:29+00:00

    The version who is working now (again) is 2112 14729.20260 (Aktueller Kanal).

    And I'm not pretty sure about the version who was not working .... but I guess it was version 2201 14827.20158 (Aktueller Kanal).

    edit: 32-bit

    edit2: The error occurred first time on 28th of January .... maybe there was also another 2112 version working fine ... I have no idea why my actual version now is lower than the latest 2112 version before updated to 2201

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments