Several checks should be performed in case of environment problems (slowness, table access errors) when running WinEur Payroll.
1 - Check the exclusions of the files used by WinEur Payroll in the anti-virus, on the data server as well as on ALL the client PCs.
2 - Check the exclusions of the file indexes for the data and system directory of WinEur Payroll.
3 - Check the SMB cache as well as the SMB session timeout.
Disabling the SMB system cache
With the advent of SMB v2/v3 protocols, and the discontinuation of SMB v1 by default (e.g. in Windows Server 2019 versions), it is necessary to adjust the file server settings so that the system cache of shared directories is not enabled.
The program may then manifest error messages such as "Access violation", "Cannot open table", etc.
For this purpose, you need to add 3 registry keys on the file server and all client computers:
Registry key directory: HKLM\System\CurrentControlSet\Services\LanmanWorkstation\Parameters\
"FileInfoCacheLifetime"=dword:00000000
"FileNotFoundCacheLifetime"=dword:00000000
"DirectoryCacheLifetime"=dword:00000000
If the keys do not exist, they must be created.
A restart of the server is necessary!
Increase of the SMB session timeout
It also happens, on networks with high latency, that the default SMB Session Timeout setting of one minute is not sufficient.
You should increase this value to, for example, 10 minutes (600 seconds), to avoid frequent connection losses.
Registry key directory: HKLM\System\CurrentControlSet\Services\LanmanWorkstation\Parameters\
"SessTimeout"=dword:00000258
If the keys do not exist, they must be created on the file server and all client stations.
A restart of the server is necessary!
The AddKeys.exe program (download) allows you to check the registry keys settings and to update them automatically if necessary.
4 - Disable caching
Disable caching (or offline availability) of shared files for the WinEur Payroll data and system directory.
5 - Check the highlighted values below.
Accessible in WinEur Payroll in the Help menu, program settings or with Shift+F1.
6 - If necessary, change the highlighted values in the registry editor
Under : \HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Borland\Database Engine\Settings\SYSTEM\INIT
7 - Check the network:
a. If there is obsolete hardware (cables, switch, network card) (not Gigabit Ethernet (GbE), 1000BASE-T certified)
b. Do not use wireless connections (WIFI)!
8 - Check the machine:
a. CPU resources
b. RAM memory resources
c. Disk resources (R/W)
d. Hardware compatibility (NAS not compatible!)
e. Operating system update
Check if the problem is reproducible locally: directly on the machine (WinEUR)