Access still runs after close

[Luis Marques]

When I close Access, it remains running on the Task Manager.

If I want to reopen it I have to shut down the Acces on the Task Manager,
otherwise Access don't open.

Could you help me?

Thanks in Advance

 

[Arvin Meyer MVP]

You most likely have a recordset variable that wasn't released after the sub
ended.

Make sure that you close all recordsets and set the variable to nothing,
like:

Exit_Here:

rst.Close
Set rst = Nothing
Set db = Nothing