If you find your self looking at an Access database issue where it reports its corrupted randomly when it accessed over a network share.
It may be related to SMB2, if the DB was fine under SMB1 then its possibly related to one of the following settings
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters]
"FileInfoCacheLifetime"=dword:00000000
"FileNotFoundCacheLifetime"=dword:00000000
"DirectoryCacheLifetime"=dword:00000000
You will need to change this on all the clients that access the DB over SMB which can be done via GPO.
https://docs.microsoft.com/en-us/windows-server/administration/performance-tuning/role/file-server/
No comments:
Post a Comment