[AccessD] Fwd: System Resources Exceeded

[Mark Simms]

Jim - the Microsoft fix calls for a registry addition in LanManServer key.Should that mod be performed on the workstation or the server or both ?

Mark Simms
marksimms at verizon.net


-----Original Message-----
From: Jim Dettman via AccessD <accessd at databaseadvisors.com>
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Cc: Jim Dettman <jimdettman at verizon.net>; 'Mark Simms' <mar.ko at verizon.net>
Sent: Fri, May 24, 2019 6:46 am
Subject: Re: [AccessD] Fwd: System Resources Exceeded

Mark,

<< the forms are causing the backend database to lock-up and require
everyone to log out.>>

OK, but what does "lock up" mean specifically?

Being that it's only Windows 10, at a wild guess, they are running into the
leasing bug:

https://support.office.com/en-us/article/access-reports-that-databases-are-i
n-an-inconsistent-state-%EF%BB%BF-7ec975da-f7a9-4414-a306-d3a7c422dc1d

 This started with build 1803 of Windows last year and there still is no fix
for it.  Microsoft recommends disabling things server side, but supposedly
you can also disable on the client side by making the following registry
changes:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Para
meters]
"FileInfoCacheLifetime"=dword:00000000
"FileNotFoundCacheLifetime"=dword:00000000
"DirectoryCacheLifetime"=dword:00000000


That's more appealing because then you are not affecting any other OS's
(leasing is a performance feature and disabling it server wide can slow
other operations down).  I suspect we'll see a fix for this sometime this
year.  Microsoft has identified the problem, but I'm sure their having to
jump through all kinds of hoops to fix something so fundamental in Windows.

 Barring that, you need to get more specific details on exactly what is
happening and the setup (i.e. is the app split, are there error messages,
are they using ctrl/alt/del, it really is just the Win 10 users 100% of the
time, etc).

 Jim.
 
-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Mark Simms via AccessD
Sent: Thursday, May 23, 2019 4:09 PM
To: accessd at databaseadvisors.com
Cc: Mark Simms
Subject: Re: [AccessD] Fwd: System Resources Exceeded

Jim - I just got the word from the users.....the forms are causing the
backend database to lock-up and require everyone to log out.Then a compact
and repair is required.Again, ONLY Win 10, not Win 7.

Mark Simms
marksimms at verizon.net

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com