Share via

MS File Permission problem using windows 11

Anonymous
2023-02-12T22:30:13+00:00

I have a office 365 microsoft access application running fine on Windows 10. When migrated to Windows 11 I get the following error when opening the database.

"The Microsoft Access database cannot open or write to "" It is already opened by another user, or you need permissions to view and write its data"

Please help!

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

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-15T23:29:47+00:00

    Yes to yor questionsl.

    I did notice the first query called has a Red "X" in fromt of it. This must have happened when the application was migrated to Windows 11.

    How do you get rid of the Red X

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-02-14T05:25:07+00:00

    Not enough details.

    Does the BE (Shared Folder permissions) include security access read/write permissions?

    Do you or you need to credential login to gain access to the shared folders?

    Is the FE folder in Trusted Locations?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-02-13T23:30:52+00:00

    This is a very simple MS Access application. Single user, tables split. FE and BE in different folders. FE brings up startup splash screen. When open is selected a macro trys open a table in the BE. That is when I get the error. The Microsoft Access database cannot open or write to "" It is already opened by another user, or you need permissions to view and write its data. This implies there is an .ldb in the BE folder ant there is not. This application was running fine in Windows 10 (office 365 version). When migrated to Windows 11 the error occurred. This is why I suspect the problem is with windows 11 security.

    Please Help

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-02-13T21:25:33+00:00

    The issue is Windows 11 security. For some reason Access thinks the BE is locked. I have read this can be caused by the security configurations. The system works fine in Windows 10.

    If you use Windows 11, would you please provide screenshots of the BE and FE folder security.

    Thank you

    Was this answer helpful?

    0 comments
  5. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2023-02-13T00:20:01+00:00

    To debug this: if you have an AutoExec macro, set a StopMacro at the top, and use the debugger to step through.

    If you have a startup form, set a Stop instruction in Form_Open and step through.

    Of course you have already checked that you have Write permission to the FE location, and Create and Write permissions to the BE location.

    Was this answer helpful?

    0 comments