Are you calling DoCmd.Quit in a Form (or with a Form opened) with a OnClose sub which queries records in the database?
In my case: A Button on 'Mainform' triggers DoCmd.Quit, but I had some code in the OnClose sub writing logout details to the database. This worked fine on Windows 10, on Windows 11 the DB would not close.
Adding
DoCmd.Close acForm, "Mainform"
before
DoCmd.Quit
did the trick.
MSAccess Does Not Close Under Windows 11
Bill Bordiuk
1
Reputation point
I'm using the Access 2010 runtime for some applications I support. These applications run fine under Windows 10 but when I run them under Windows 11 the MSAccess executable still runs in the background when I quit the application using DoCmd.Quit. I've noticed that this happens any time a form is open that runs any VBA code. Is this a know issuer with Windows 11? I've seen similar issues with Office 365 but this is with the runtime version.
1 answer
Sort by: Most helpful
-
Pete de Greet 1 Reputation point
2022-09-12T09:21:02.27+00:00