We help IT Professionals succeed at work.

SMBLeasing bug fix

Derek Brown
Derek Brown asked
on
When using the latest fix for the access 365/windows 10 issue do I need to undo the SMBLeasing microsoft bug fix?
Comment
Watch Question

Author

Commented:
This is our latest advised and modified fix:

1.      At start type in cmd, don’t just hit return, select “Run as Administrator”
2.      Drop the file into the folder that the command prompt opens up at this time (probably C:\WINDOWS\system32)
3.      Then just type in accessfix
4.      The output you should get is;

C:\WINDOWS\system32>accessfix
C:\WINDOWS\system32>reg add HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters /v FileInfoCacheLifetime /t REG_DWORD /d 0 /f
The operation completed successfully.
C:\WINDOWS\system32>reg add HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters /v FileNotFoundCacheLifetime /t REG_DWORD /d 0 /f

The operation completed successfully.
C:\WINDOWS\system32>reg add HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters /v DirectoryCacheLifetime /t REG_DWORD /d 0 /f

The operation completed successfully.

C:\WINDOWS\system32>
Daniel PineaultPresident / Owner CARDA Consultants Inc.
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
When using the latest fix for the access 365/windows 10 issue
I am unaware of any new fix.  The SMBLeasing hack remain the only MS approved workaround.  Nothing has officially changed: https://support.office.com/en-us/article/access-reports-that-databases-are-in-an-inconsistent-state-%EF%BB%BF-7ec975da-f7a9-4414-a306-d3a7c422dc1d
President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
<<When using the latest fix for the access 365/windows 10 issue do I need to undo the SMBLeasing microsoft bug fix? >>

 Yes.  They have not released a fix as yet.

 I don't understand why not.  All they need to do (I think) is add a registry key for includes/excludes of file types for the leasing.   Seems simple, but they haven't done anything like that, so there must be a lot more to it then that.

Jim.

Author

Commented:
Sorry I got this from Daniel in another post. It is a users fix. (By the way Daniel I posted that you solved that one but I did not or could not get the little form that asks you to rate the providers answer so hope you got it)

https://www.devhut.net/2018/06/13/access-bug-database-is-in-an-unrecognized-format/ 

In this article it states:
The Workaround proposed by Microsoft (actually was found by a community user in one of the 1st discussion when the bug was first reported) is one possible solution, but does have it’s drawbacks: requires administrative priviledges on the PC/Server housing the back-end, appears to cause performance issues for some.

and

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters]
"FileInfoCacheLifetime"=dword:00000000
"FileNotFoundCacheLifetime"=dword:00000000
"DirectoryCacheLifetime"=dword:00000000

You save it to a bat file and simply execute it, et voila, no more problem.

We tried it with a .bat file and that did not work so we modified it as at my second post.

Author

Commented:
As the SMBLeasing "appears to cause performance issues for some" and definitely has for my user I wonder if this fix needs to be reversed.
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
<<As the SMBLeasing "appears to cause performance issues for some" and definitely has for my user I wonder if this fix needs to be reversed. >>

 At some point it does.   Your turning off leasing for everything when all you need is to turn it off for Access (or Quickbooks or any other multi-user file that doesn't place locks on the DB itself).  For everything else, it's a performance loss.
 
 Leasing allows for client side caching of a file, meaning it doesn't have to keep writing data back to the server all the time.  You can only do that however when one user is in the file.

Jim.

Author

Commented:
It makes you wonder how that SMBLeasing was considered a fix in the first place.
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
<<It makes you wonder how that SMBLeasing was considered a fix in the first place. >>

 It's not.  It's considered a temporary workaround for those running Access applications.

Jim.
Daniel PineaultPresident / Owner CARDA Consultants Inc.
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
That should be a reg file, not a bat file.

Temporary
Hmmmmmmm?!

Author

Commented:
My thanks as usual!!