Access Database is getting corrupt again and again

I don’t use Inno Setup, but I did evaluate it and still have it on my PC. The Inno Script Studio has a Registry section where you can add these values. That is essentially how I do it in the setup program I use.

We have an application which was working okay till last month. But after the last windows update our clients are getting issues with access database. access database got corrupted.  We ran compact and repair. But it still getting corrupted again and again.  This issue started right after the window update. clients are on different OS. Like server 2018, server 2012 and windows 10.

Is there anything i have check in new windows update or any other step to prevent database corruption?

I had this same problem running our database over a mapped drive or UNC path from our server (SBS2011) after introducing Windows 10 machines and a new Server 2016. Randomly the database would corrupt or crash when using it. I scoured the logs and found it coinciding with group policy refreshing in the back ground. To test the theory i opened the database and ran 'gpupdate /force' hey presto, corrupt and crashed database. It wouldn't corrupt all the time mostly crash. So I used group policy to 'turn off background refresh'........worked a charm.

1. Hold down the Windows Key and press “R” to bring up the Run command box.
2. Type “gpedit.msc“, then press “Enter“.
3. In the “Local Computer Policy“, go to “Computer Configuration” > “Administrative Templates” > “System” > “Group Policy“.
4. Open the “Turn off background refresh of Group Policy” setting.
5. Set this setting to “Enabled“, then select “OK“.

Hope this helps someone.

You need to name the file regfix.reg and then run that file.

I do not know how a .reg file would run in the instance you are using. We just save the file to the desktop and then run to add to the registry.

Hope that helps.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters]

"FileInfoCacheLifetime"=dword:00000000

"DirectoryCacheLifetime"=dword:00000000

"FileNotFoundCacheLifetime"=dword:00000000

He says: This approach is more easily implemented in my setup program

Can I ask how Mark did this?

I think I will go down this route

I use Inno setup as the installation program

Can someone advise the best way to do this?

I was thinking...

Do I create a .bat  'regfix.bat' with these exact 5 lines above, include them in the install program and then run the bat file at the end of the install program?

[Run]
Filename: "{app}regfix.bat"; Parameters: "install"; Flags: runhidden

I posted this thread earlier about coping files. I do not know why it worked but it did.

Has anyone read through that thread it might provide some additional incites to what the issue is here (it is only 2 pages as opposed to the 33 here).

It is curious why it showed up in Access a year or so before it showed up when coping files???

https://answers.microsoft.com/en-us/windows/forum/all/drag-and-drop-to-network-folder-icon-not-working/d6db3ede-1cea-490d-bf49-339d178174b0?auth=1&page=1