Access instance remains in memory once closed (1 Viewer)

[mloucel]

I'm still regularly experiencing this issue. Have to go into task manager several times a day to clear them out.

I honestly never noticed, it was just after last week that I started to dig a bit more, my computer thou I have 32 g of ram, it was going slow and my application acted erratically, I was just saying is cache issues, or memory corruption, or too many things, so I was doing what I preach, RTDT, and problem fixed [Reboot The Darn Thing], but I was getting a bit frustrated, until I decided to look it up, and to my surprise last week I found almost 22 instances of Access open, then after I close all of them, I kept my TM open, and to my surprise, after the quit 8 out 10 was left in the void.
So I look for solutions, and I have tried almost anything, I am going to try @arnelgp solution and report back.

 

[RonPaii]

Have you considered rebooting your computer once a day? A lot of software handle resources poorly, reboot cleans that up. I use CAD software and it has documentation to improve performance; it suggest giving your computer a lunch break by rebooting.

Another thing that will slow down your computer is stale USB devices. Each time you insert a USB device, Windows stores the information in the Registry. Those now missing devices get referenced causing delays. I "install" 2 Microsoft tools on every computer "SystemInternalsSuite" and "DevNodeClean"; Install is in quotes because these are all single call exe files, nothing is really installed on your computer. DevNodeClean will delete all the old shadow copy references for those missing USB drives.

Next go to device manager.
In "View" click on "Show Hidden Devices"
Expand each section looking of greyed out devices. Leave the Microsoft ones.

Note the devices after my main hard drive.
Look at Human Interface, Keyboards, Mice, Monitors, Portable Devices

 

[Gasman]

Be easier to just delete the processes, wouldn't it

' ProcessKillLocal.vbs
' Sample VBScript to kill a program
' Author Guy Thomas http://computerperformance.co.uk/
' Version 2.7 - December 2010
' ------------------------ -------------------------------' 
Option Explicit
Dim objWMIService, objProcess, colProcess
Dim strComputer, strProcessKill 
strComputer = "."
strProcessKill = "'msaccess.exe'" 

Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\\" _ 
& strComputer & "\root\cimv2") 

Set colProcess = objWMIService.ExecQuery _
("Select * from Win32_Process Where Name = " & strProcessKill )
For Each objProcess in colProcess
objProcess.Terminate()
'Next 
WSCript.Echo "Just killed process " & strProcessKill _
& " on " & strComputer

Next
WScript.Quit 
' End of WMI Example of a Kill Process

 

[RonPaii]

Be easier to just delete the processes, wouldn't it

' ProcessKillLocal.vbs
' Sample VBScript to kill a program
' Author Guy Thomas http://computerperformance.co.uk/
' Version 2.7 - December 2010
' ------------------------ -------------------------------'
Option Explicit
Dim objWMIService, objProcess, colProcess
Dim strComputer, strProcessKill
strComputer = "."
strProcessKill = "'msaccess.exe'"

Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\\" _
& strComputer & "\root\cimv2")

Set colProcess = objWMIService.ExecQuery _
("Select * from Win32_Process Where Name = " & strProcessKill )
For Each objProcess in colProcess
objProcess.Terminate()
'Next
WSCript.Echo "Just killed process " & strProcessKill _
& " on " & strComputer

Next
WScript.Quit
' End of WMI Example of a Kill Process

Is that the same as the command line

taskkill /im MSACCESS.exe /t /f

? Killing all instances of Access?

 

[Gasman]

I would think so.

 

[mloucel]

Be easier to just delete the processes, wouldn't it

' ProcessKillLocal.vbs
' Sample VBScript to kill a program
' Author Guy Thomas http://computerperformance.co.uk/
' Version 2.7 - December 2010
' ------------------------ -------------------------------'
Option Explicit
Dim objWMIService, objProcess, colProcess
Dim strComputer, strProcessKill
strComputer = "."
strProcessKill = "'msaccess.exe'"

Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\\" _
& strComputer & "\root\cimv2")

Set colProcess = objWMIService.ExecQuery _
("Select * from Win32_Process Where Name = " & strProcessKill )
For Each objProcess in colProcess
objProcess.Terminate()
'Next
WSCript.Echo "Just killed process " & strProcessKill _
& " on " & strComputer

Next
WScript.Quit
' End of WMI Example of a Kill Process

Sorry but I am confused in this line, can you explain:

Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\\" _
& strComputer & "\root\cimv2")

I've never worked with anything similar to that code, I understand is a vbs script and the logic i got it, but that line, how do I find what is the correct string for my computer?
Thanks.

 

[mloucel]

Have you considered rebooting your computer once a day? A lot of software handle resources poorly, reboot cleans that up. I use CAD software and it has documentation to improve performance; it suggest giving your computer a lunch break by rebooting.

Another thing that will slow down your computer is stale USB devices. Each time you insert a USB device, Windows stores the information in the Registry. Those now missing devices get referenced causing delays. I "install" 2 Microsoft tools on every computer "SystemInternalsSuite" and "DevNodeClean"; Install is in quotes because these are all single call exe files, nothing is really installed on your computer. DevNodeClean will delete all the old shadow copy references for those missing USB drives.

Next go to device manager.
In "View" click on "Show Hidden Devices"
Expand each section looking of greyed out devices. Leave the Microsoft ones.
View attachment 122976
Note the devices after my main hard drive.
Look at Human Interface, Keyboards, Mice, Monitors, Portable Devices

by rule of thumb, I always turn off my computer at the end of the day, [Yes fast startup is disabled], but the other tips are really good, I'll check.

 

[Gasman]

Sorry but I am confused in this line, can you explain:

Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\\" _
& strComputer & "\root\cimv2")

I've never worked with anything similar to that code, I understand is a vbs script and the logic i got it, but that line, how do I find what is the correct string for my computer?
Thanks.

It is the code posted?
I have never tried it on a remote computer, always the local computer.
One could hard code it perhaps?, but instead of a period, that might well be the name of a computer. Never experimented with that, just used it as I found it.

 

[RonPaii]

It is the code posted?
I have never tried it on a remote computer, always the local computer.
One could hard code it perhaps?, but instead of a period, that might well be the name of a computer. Never experimented with that, just used it as I found it.

impersonationLevel=impersonate is the default, but it don't hurt to add it.

see

Impersonation Levels (COM) - Win32 apps

If impersonation succeeds, it means that the client has agreed to let the server be the client to some degree.

learn.microsoft.com

Set the default process security level with VBScript - Win32 apps

A script can use the default WMI authentication and impersonation settings. However, the script may need a connection with more security or may connect to a namespace that requires an encrypted connection.

learn.microsoft.com

 

[mloucel]

impersonationLevel=impersonate is the default, but it don't hurt to add it.

see

Impersonation Levels (COM) - Win32 apps

If impersonation succeeds, it means that the client has agreed to let the server be the client to some degree.

learn.microsoft.com

Set the default process security level with VBScript - Win32 apps

A script can use the default WMI authentication and impersonation settings. However, the script may need a connection with more security or may connect to a namespace that requires an encrypted connection.

learn.microsoft.com

Ok.. So the clue is here..

strComputer is a fixed object that we can easily do with vba code:

Environ("ComputerName")

I have to try this approach.


NEVERMIND..
WHAT HAPPENS WHEN YOU DO NOT READ THE CODE ENOUGH TIMES..
The solution is right there in the code, OLD MSDOS trick:

Dim strComputer, strProcessKill
strComputer = "." '<<<<<-----------'
strProcessKill = "'msaccess.exe'"

Thanks.

 

[mloucel]

Hello everyone, I am not sure if this is going to help, finding the culprit of this behavior in access but look at the picture, I am trying to find out why the difference in the icons of access when closing, these are 4 different times, and the icons are different for all of them.
I hope someone with more knowledge than me can figure out.
I am testing tomorrow the code that @Gasman shared, nevertheless.

 

[The_Doc_Man]

You have two different icons, not four. I've seen the different icons before in Windows Task Manager (WTM).

The 1st and 4th represent the open app file (because the icon includes that dog-eared document image behind the "A"). The 2nd and 3rd represent that part of Access associated with MSACCESS.EXE, which I believe appears when you launch Access multiple times. There is a setting in WTM that allows you to choose how you display child processes. On my system, I get the Access icon that looks like a stack of poker chips as the parent and the icon that has a dog-eared document as the child. The parent process name aligns with other tasks but the child name is indented a couple of spaces. The parent usually has a ">" to its left and if you click it, it alternately shows or hides its process "tree."

Or, regarding "4 times and the icons are different for each" - are you suggesting that the Dolby and Global.Accounts icons are ALSO part of Access?

 

[mloucel]

You have two different icons, not four. I've seen the different icons before in Windows Task Manager (WTM).

The 1st and 4th represent the open app file (because the icon includes that dog-eared document image behind the "A"). The 2nd and 3rd represent that part of Access associated with MSACCESS.EXE, which I believe appears when you launch Access multiple times. There is a setting in WTM that allows you to choose how you display child processes. On my system, I get the Access icon that looks like a stack of poker chips as the parent and the icon that has a dog-eared document as the child. The parent process name aligns with other tasks but the child name is indented a couple of spaces. The parent usually has a ">" to its left and if you click it, it alternately shows or hides its process "tree."

Or, regarding "4 times and the icons are different for each" - are you suggesting that the Dolby and Global.Accounts icons are ALSO part of Access?

Thanks Doc, I think I was a bit late in the night writting, what I meant to say was, that 1 application opened those 4 times, at least to my knowledge my app open once and then opens a splash, a login, a menu, and the menu has different windows depending on the needs of the EU.
So yes you are correct, there are only 2 sets of icons.

Thank you for correcting me.