WHAT DOES MICROSOFT ACCESS DO SOFTWARE
Proper top-end client-server SQL databases like PostgreSQL, MariaDB/MySQL, Firebird, and SQL Server Express are now cheaper than Access and FileMaker, and as enterprise solutions have a much better ecosystem of interoperable software and utilities. The most elegant solution is to stop using MS Access (and FileMaker, and probably SQLite) multiple-access over fileshares. Perhaps it's gotten worse or better over the years, but it was a problem in the past and it's going to be a problem in the future. This is more or less inevitable with MS Access shared access, I believe. There's been a surge of MS Access accdb files that become corrupted or getting into an, "inconsistent state" when the connection of clients and server is via LAN. Now it doesn't make sense to me.Ĭan someone give a more sensible answer as to what file server leasing is? What disabling it does? And how disabling it becomes microsoft's workaround for the "inconsistent state" of LAN-connected MS Access db servers?Īlso, how do I enable this back in case I want to? I've tried looking around google and asking some network engineers about file server leasing, and what I mostly found is some sort of financial arrangement between the server and client for using the server capacity to store files. This was supposed to disable the leasing on the file server where the database is stored and the client machine where Microsoft Access is running. REG ADD HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters /v DisableLeasing /t REG_DWORD /d 1 /f
The workaround they are currently providing is doing in the command prompt as follows: Not really sure if this is the right place to ask the question, so in case I have to go post this in another sub, please just let me know.Īnyway, since at least last year, there's been a surge of MS Access accdb files that become corrupted or getting into an, "inconsistent state" when the connection of clients and server is via LAN.