Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

MS Access Inconsistent State. Applying Registry Hack Applied to Each PC

Avatar of Dale James
Dale James asked on
Microsoft AccessCitrixWindows 10
7 Comments1 Solution40 ViewsLast Modified:
Hello Team
My apologies for posting yet another question relating to the ongoing MS Access Inconsistency error.

I have a split MS Access database with the backend stored in network server.

The users have their frontend copy stored on the desktop of Windows 10 and are operating on Citrix.

Taking these software elements into consideration, I am unsure how reliable it would be to apply the current Microsoft workaround of:

REG ADD HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters /v DisableLeasing /t REG_DWORD /d 1 /f
NET STOP SERVER
NET START SERVER

I am just concerned about applying this to the network in case it creates additional issues elsewhere and to be honest, IT will be very hesitant (as usual)  to implement such changes.

I have also came across then alternative workaround of applying the PC registry hack, whereby the registry settings are changed on each individual PC so that there is no impact at a Network/Server level.

Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters] "FileInfoCacheLifetime"=dword:00000000 "FileNotFoundCacheLifetime"=dword:00000000 "DirectoryCacheLifetime"=dword:00000000
 Can anyone advise if the individual PC hack is a viable option and if there are any known drawbacks or impacts to the individual PC when applied?

If it is a viable option, can anyone also advise they best way to apply this change to the individual PCs?

As always...any advise is much appreciated.

Sincerely

Dale