We help IT Professionals succeed at work.

SMBLeasing?

We have a very well sorted database application. Runs fine on everything except Windows 10 in 64 bit environment. Have had great help in the past with SMBLeasing causing data to go into incompatible state. Despite all customers having this disabled I still get regular Disc or file error. I have had a full list of all checks on the network from you guys but unable to stop this with 2 out of 20 clients. I can only assume that with access 2002 as our runtime that something else must be adrift.

Do I
1. Struggle on looking for the answer to the problem
2. Move to Access 16 in 64 bit mode, copy with the irritating ribbon and offer two versions of our application?
Comment
Watch Question

Daniel PineaultPresident / Owner CARDA Consultants Inc.
BRONZE EXPERT
Distinguished Expert 2018

Commented:
What is the exact error your users are receiving?  Disc and File error are not symptomatic of the Windows 10 SMBLeasing issue (unrecognized databse...).

Does your db establish a persistent connection at the startup?
Are all the users on the same wired LAN?

Why in your choices are you wanting to change bitnesses if you migrate to 2016?  I would stick with 32-bit unless there was a distinct reason to change (which in 99% of cases in not the case).

Author

Commented:
"What is the exact error your users are receiving?  Disc and File error are not symptomatic of the Windows 10 SMBLeasing issue (unrecognized databse...)." From the customers description (I don't have direct access to it at the moment) "Disc or file error. The error may not result in incorrect macro name Etc.etc."

'Does your db establish a persistent connection at the startup"  Yes

"Why in your choices are you wanting to change bitnesses if you migrate to 2016?" I am assuming that if the only time we have a problem is when we install onto a clients 64 bit environment that this may have something to do with it.
Daniel PineaultPresident / Owner CARDA Consultants Inc.
BRONZE EXPERT
Distinguished Expert 2018

Commented:
In my experience, disk errors usually have to do with networking, saturation, wireless connections and the likes.
Have you validated they are running on a wired LAN, no wireless anywhere in the mix?
What about network saturation/latency...?
What is the db size?
When was it last compacted?
The db is split and each user has their own local copy of the fe, no sharing a common file?
Does the error ocur randomly, or is this a reproducible issue?

Author

Commented:
Latency was less tha 9ms and typically 1ms
The current issue is with an external drive rather than a network. But all other issues have been with servers.
DB size is 4MB
The last time was a week ago where I opened the data and got a message that the data needed repairing. It then works fine for a week then regular problems there after 3 or 4 times per day when all fields go to error.
Each pc has it's own front accessing same data on the external hard drive. On one system it erred every 90 minutes. This one I don't know because it is used randomly
President / Owner CARDA Consultants Inc.
BRONZE EXPERT
Distinguished Expert 2018
Commented:

Author

Commented:
Thank you for that Daniel. I was aware of a previous post where we tried the smbleasing fix and it has indeed caused serious problems for our client.. They now have only one pc running our program out of three. The other two run so slow that they are unusable. It really is making my company look stupid. they, of course, do not believe that it is a Microsoft issue. So we are the bad boys at the moment.  I read the entire article and your comments. I will be trying to get into the client next week. We will be moving the data to another location and running that small batch file and hope that it fixes the issue.

Very helpful. Thank you
Daniel PineaultPresident / Owner CARDA Consultants Inc.
BRONZE EXPERT
Distinguished Expert 2018

Commented:
As for them not believing you, simply send them the link to MS' official page on the issue, this is what I've done.   And yes, Microsoft is making the entire community look very bad.  Two years to address such a critical issue is two year too long.

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

Author

Commented:
For some reason, as a bat file, this will not run:

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

Anybody know why?

Author

Commented:
Any reason why this would not work:

1.      At start type in cmd, don’t just hit return, select “Run as Administrator”
2.      Drop the file into the folder that the command prompt opens up as this time (probably C:\WINDOWS\system32)
3.      Then just type in accessfix2.
4.      The output you should get is;

C:\WINDOWS\system32>accessfix2
C:\WINDOWS\system32>reg add HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters /v FileInfoCacheLifetime /t REG_DWORD /d 0 /f
The operation completed successfully.
C:\WINDOWS\system32>reg add HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters /v FileNotFoundCacheLifetime /t REG_DWORD /d 0 /f

The operation completed successfully.
C:\WINDOWS\system32>reg add HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters /v DirectoryCacheLifetime /t REG_DWORD /d 0 /f

The operation completed successfully.

C:\WINDOWS\system32>

Explore More ContentExplore courses, solutions, and other research materials related to this topic.