On 12/14/2021, SemiAnnual Enterprise channel updated to version 16.0.13801.21086. This is causing several strange behaviors in Microsoft Access. For example: Create a new Access database on a network drive or open an existing database from a network drive. Close it. The .laccdb file is not automatically deleted (even though no other users are in it). Use DAO to OpenDatabase for shared (non-exclusive) access. Error 3050 (“Could not lock file.”) is thrown and the database is not opened. Databases opened on a network drive appear to always be opened for exclusive access. Once one person has opened a database, others can't--even when opening for shared access. Reverting to the prior version 16.0.13801.21050 fixes the problem. This problem seems specific to databases located on a network share. For databases on a local machine, there is no issue.

There will be an update for Office 2013 soon, but it is not yet available.

The issue with the MEC update should now be resolved, you should be able to use WSUS\SCCM now.

In my department we run 2 tools. One is a multi-user tool with a shared backend on a network drive and we have issues as described. Advancing to build 13801.21092 later today to see if that fixes the issue.Another is a tool that runs locally on PC hard drive with only 1 user. Even here we are affected - it is extremely slow. Have confirmed that rolling back from 16.0.13801.21072 to 16.0.13801.21050 solves the issue. I have logging in place and a loop like this is much slower. Fingers crossed that 21092 will solve this as well. set rs = CurrentDb.OpenRecordset(name:="LocalDBTable", Type:=RecordsetTypeEnum.dbOpenDynaset) For each bla in blaCollection.items 'count = 400 items With rs .AddNew !FieldA = bla.aNewValue '.... !FieldZ = bla.zNewValue .Update End With Next bla rs.Close set rs = nothing

Are you using a DFS Namespace, or other means of redirecting from the actual database location to an aliased path/filename? DFS. On the mapped drive where the Access files exist, DFS tab, I see a server specified in the referral list. Shows "Active". I don't manage that, but on that server, neither of the DFS roles are turned on, but it shows up under the DFS tab when I view the properties of the mapped drive.

Lock File Problems with Access 16.0.13801.21086

Anonymous

On 12/14/2021, SemiAnnual Enterprise channel updated to version 16.0.13801.21086. This is causing several strange behaviors in Microsoft Access. For example:

Create a new Access database on a network drive or open an existing database from a network drive. Close it. The .laccdb file is not automatically deleted (even though no other users are in it).
Use DAO to OpenDatabase for shared (non-exclusive) access. Error 3050 (“Could not lock file.”) is thrown and the database is not opened.
Databases opened on a network drive appear to always be opened for exclusive access. Once one person has opened a database, others can't--even when opening for shared access.

Reverting to the prior version 16.0.13801.21050 fixes the problem.

This problem seems specific to databases located on a network share. For databases on a local machine, there is no issue.

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

98 answers

Anonymous

2021-12-21T21:36:16+00:00

There will be an update for Office 2013 soon, but it is not yet available.
Was this answer helpful?

1 person found this answer helpful.

0 comments No comments
Anonymous

2021-12-21T21:48:45+00:00

The issue with the MEC update should now be resolved, you should be able to use WSUS\SCCM now.
Was this answer helpful?

0 comments No comments
Anonymous

2021-12-22T08:31:25+00:00
In my department we run 2 tools. One is a multi-user tool with a shared backend on a network drive and we have issues as described. Advancing to build 13801.21092 later today to see if that fixes the issue.Another is a tool that runs locally on PC hard drive with only 1 user. Even here we are affected - it is extremely slow. Have confirmed that rolling back from 16.0.13801.21072 to 16.0.13801.21050 solves the issue. I have logging in place and a loop like this is much slower. Fingers crossed that 21092 will solve this as well.
```
set rs = CurrentDb.OpenRecordset(name:="LocalDBTable", Type:=RecordsetTypeEnum.dbOpenDynaset)  

For each bla in blaCollection.items 'count = 400 items  

    With rs          

        .AddNew  

        !FieldA = bla.aNewValue  

 '....  

        !FieldZ = bla.zNewValue  

        .Update  

    End With  

Next bla  

rs.Close  

set rs = nothing
```
Was this answer helpful?

0 comments No comments
Anonymous

2021-12-22T12:56:07+00:00

Thank you!!
Was this answer helpful?

0 comments No comments
Anonymous

2021-12-23T04:21:41+00:00

Are you using a DFS Namespace, or other means of redirecting from the actual database location to an aliased path/filename?

DFS. On the mapped drive where the Access files exist, DFS tab, I see a server specified in the referral list. Shows "Active". I don't manage that, but on that server, neither of the DFS roles are turned on, but it shows up under the DFS tab when I view the properties of the mapped drive.
Was this answer helpful?

0 comments No comments