CODEWITHSUNDEEP
vbams-accessprocess
Francisco Testor
Francisco Testor

Reputation: 11

Office 365 version 2201 leaves ghost background processes in task manager after quitting msaccess

When using the object currentproject in msaccess, and exiting the application with quit, I cannot get rid of ghost files/background_processes of Access in the task manager. How do I fix this?

Just a form with two buttons with the code show the difference. :

Button Exit: no background process is created

Private Sub Exit_Click()  
    Application.Quit  
End Sub

Button MakeGhostService: a ghost Process is created every time I quit.

Private Sub MakeGhostProcess_Click()  
    Dim nilvar As String  
    nilvar = CurrentProject.Name  
    Application.Quit  
End Sub

In both cases, Access disappears from the Apps section in the Task Manager and then appears a new background process of Access. For the case where Exit is clicked, the background process disappears 1 or 2 seconds later. For the other button it remains.

if I open again Access, run the form, and press makeGhostProcess, again exits Access leaving a new instance of access as a Background Process and I can get as many instances at the same time as I run the form and press the damn button.

Upvotes: 1

Views: 1263

Answers (3)

Thomas
Thomas

Reputation: 1

I've got the same problem as you and I found your post. I have tried your file Database10 with my access version (2210) and the processes in the background appears. I think it's a bug of the 2201 version of access. This problem did not exist before.

Upvotes: 0

Peter Diem
Peter Diem

Reputation: 1

Same problems (Access 2021: 2201 build 16.0.14827.20158):

According to many posts in the last days M365 Current Channel version 2201 build 16.0.14827.20158 of Jan 26 causes 16.0.14827.20158 of Jan 26 causes

a persistent .laccdb, an Access ghost process error 3048 cant open any more databases other errors like "already in use by Admin"

additional error: 3035 today so i try to go back to an erlier version (2112 14729.20260) 12 january

Upvotes: 0

Andre
Andre

Reputation: 27644

I just found this post by Karl Donaubauer:

Access doesn't close properly. A remaining background process can only be terminated in task manager.

Karl Donaubauer replied to Florian1290

‎Feb 02 2022 02:39 AM - edited ‎Feb 02 2022 02:44 AM

You are not alone. There are reports about it in all Access forums of the world. I answered it like this several times:

According to many posts in the last days M365 Current Channel version 2201 build 16.0.14827.20158 of Jan 26 causes

  • a persistent .laccdb, an Access ghost process
  • error 3048 cant open any more databases
  • other errors like "already in use by Admin"

The only remedy so far is to revert back to an older build of M365. See also the M365 version history.

I've reported it to Microsoft, too.

Servus Karl

Upvotes: 0

Related Questions