Forum Discussion

Ales128's avatar
Ales128
Copper Contributor
Dec 24, 2021

Ms Access, after opening the database with the /decompile key, leaves the database in exclusive mode

For many years I have been running the Ms Access database with the /decompile key and it remained in multi-user mode after decompilation (I did not close the database). But a week ago, about after up...
2013
access
isladogs's avatar
isladogs
MVP
Dec 24, 2021

This is almost certainly due to a flawed Windows security update that was released last Tuesday (14 Dec). Remarkably MS acknowledged the bug the next day and released a fix just two days later. Whilst it would have been far better to have done thorough testing and avoided the issue, the speed of response was very impressive.

 

Anyway, you can find out more here including how to get the fix
https://support.microsoft.com/en-us/office/error-in-access-when-opening-a-database-on-a-network-file-share-6cbc1560-62c2-46e7-9980-d079a46f5acc

 

BTW Although I also use the /decompile switch whenever necessary to fix issues during development and before deployment, I personally wouldn't use it each time the database is opened by end users. What benefit is there as end users shouldn't be able to edit code.

  • Ales128's avatar
    Ales128
    Copper Contributor
    Dec 30, 2021

    isladogs Thanks for the reply. I was waiting for the next MS Office update to decide if it would help. A security update came out today and I installed it (screenshot attached to the message)
    Now the situation is like this: when I open the database on the way like D:\BZD \... - no problem, other programs have access to the database file
    But when I open the database by the path type \\COMPNAME\BZD\..., then it is blocked and there is no access for other programs to it
    After installing the updates, I restarted the computer, removed the path \\COMPNAME\BZD\ and re-created it (write access for EVERYONE)
    (automatic translation)

    • Karl_Donaubauer's avatar
      Karl_Donaubauer
      MVP
      Dec 30, 2021

      Hi,

       

      Yes, after the initial fixes there are still problems with network paths. One of them has been admitted by Microsoft in the "Note" of the support article, but it isn't just DFS paths.

       

      New information in the article and fixes for some of the network paths problems should follow. However, until that details are not clear and the only solutions to get rid of the problem is to uninstall the causing security updates, which of course isn't possible everywhere. See also: Information about the ability to uninstall Office

       

      Servus
      Karl
      ************
      Access News
      Access DevCon

       

Resources