MS Access 2016 database is opening longer after Windows update

%3CLINGO-SUB%20id%3D%22lingo-sub-1744589%22%20slang%3D%22en-US%22%3EMS%20Access%202016%20database%20is%20opening%20longer%20after%20Windows%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1744589%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22%22%3EI'm%20running%20MS%20Access%202016%20database%20from%20shared%20disk%20that%20is%20opening%20from%20two%20computers%20in%20the%20network.%20After%20installation%20of%20the%20latest%20Windows%2010%20update%20v.%202004%20(%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F4571756%2Fwindows-10-update-kb4571756%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F4571756%2Fwindows-10-update-kb4571756%3C%2FA%3E)%20the%20opening%20database%20from%20one%20computer%20takes%20about%2010%20seconds%20and%20also%20some%20operations%20like%20opening%20forms%20sometime%20takes%204-5%20seconds.%3C%2FP%3E%3CP%3EAlso%20re-running%20the%20query%20sometimes%20fails%20with%20error%203420%20(Object%20Invalid%20or%20No%20Longer%20Set).%20When%20the%20update%20is%20uninstalled%20then%20everything%20is%20running%20fine%20as%20before.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1744589%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1803826%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Access%202016%20database%20is%20opening%20longer%20after%20Windows%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1803826%22%20slang%3D%22en-US%22%3EAre%20you%20running%20the%20queries%20through%20VBA%20or%20through%20the%20GUI%20by%20simply%20double-clicking%20on%20them%3F%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20the%20database%20split%3F%3CBR%20%2F%3EEach%20user%20has%20their%20own%20copy%20of%20the%20front-end%20locate%20locally%20on%20their%20PC%3F%3CBR%20%2F%3ELinked%20tables%20are%20married%20using%20UNC%20or%20IP%20and%20not%20mapped%20drive%3F%3CBR%20%2F%3EWhen%20was%20the%20last%20time%20the%20databases%20(back-end%20and%20front-end)%20were%20compacted%3F%3CBR%20%2F%3EWhat%20is%20your%20current%20build%20number%2C%20bitness%20and%20update%20channel%3F%3CBR%20%2F%3EHave%20you%20tried%20updating%20our%20reverting%20your%20Office%20installation%3F%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I'm running MS Access 2016 database from shared disk that is opening from two computers in the network. After installation of the latest Windows 10 update v. 2004 (https://support.microsoft.com/en-us/help/4571756/windows-10-update-kb4571756) the opening database from one computer takes about 10 seconds and also some operations like opening forms sometime takes 4-5 seconds.

Also re-running the query sometimes fails with error 3420 (Object Invalid or No Longer Set). When the update is uninstalled then everything is running fine as before.

1 Reply
Highlighted
Are you running the queries through VBA or through the GUI by simply double-clicking on them?

Is the database split?
Each user has their own copy of the front-end locate locally on their PC?
Linked tables are married using UNC or IP and not mapped drive?
When was the last time the databases (back-end and front-end) were compacted?
What is your current build number, bitness and update channel?
Have you tried updating our reverting your Office installation?