Windows 11 Slowing Down Database

[CJ_London]

If that was for me, yes definitely a split as I would always do,

so it's not split and all users are opening the file on the server - that way lies corruption.

 

[MagicIT]

In addition to the comments above regarding BIT Locker and Antivirus, there is another overlooked area within access itself that affects performance. If you have compression enabled, that could also lead to performance issues.

As for anti-virus, a lot of System Admins like to blame software for their weaknesses, and a lot them are highly prejudicial on Office Products, especially Access. They will implement Anti-virus and harden it to the point where applications just stop functioning or become terribly slow. Access itself is not the culprit. A trusted application should be placed in a trusted location where there is no pro-active defense. I personally do not run any 3rd party anti-virus software. I rely entirely on built-in windows security. I have had nothing but bad experiences with all the popular 3rd anti-virus software, mainly regarding performance of office products.

Also, if you are running any Emulator Software, make sure your Office components have been updated. Older Emulators like to install office core dll's in the older folder structures. The problem is this cause ambiguity when certain functions are called.

I am not sure why or how upgrading from Windows 10 to 11 would affect this, but it is worth looking into. Make sure the "Name AutoCorrect Options" are disabled in your production application. Thise feature is enabled by default in new Access Databases. This feature tracks name changes to objects and can track in run mode if enabled.

View attachment 119834

No compression that I have found anywhere as yet and all the usual performance issues are already covered including autocorrect, trusted locations, subform datasheets, export and import of all objects, decompile/recompile, persistent BE, indexes etc. For AV, I can only go on what their support provider told me that they had excluded what I told them to for both realtime and scheduled scans, but I might have more on that soon as another provider has been brought in, given how useless and awkward their incumbent one is.

Also suggested getting their cabling infrastructure actually tested given they had some fluctuation and improvement whilst some PCs were moved out of the way for decorating (not unusual to have a good few days though anyway) and some has been added later on. Also want to ensure all the PCs are up to date on NIC firmwares etc.

 

[MagicIT]

so it's not split and all users are opening the file on the server - that way lies corruption.

Sorry, but that's not what I said. I said it IS split. Back end files are on the server and each workstation with its own front end locally on the C: drive just as I would always do.