Hi everyone
Today less and less people use msaccess, but some still, and some still use multiuser database.
In such case after Windows 2008 R2 it can cause problem with new layer of SMB version, that allow oplock to be used, thus it can cause bug from the Access GUI, or even corruption of the data file.
To disable, on the server :
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MRXSmb\Parameters\
OplocksDisabled REG_DWORD 0 or 1
Default: 0 (not disabled)
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters
EnableOplocks REG_DWORD 0 or 1
Default: 1 (enabled)
To be disabled at 100% let’s do the client’s computers too. Easily with a GPO
Phil’s Blog | IT to the core ! 