Probs when closing Access 2002

B

Baby Face Lee

Hi there,
I wonder if any of you have experienced the same problem as me?
When I've been working on a database for a while, when close it down loads
of processes/apps are opened (minimized). It's like the contents of the
Processes part of Task Manager have been opened. It's really weird and
pretty frustrating as I have to reboot my PC to continue. It doesn't usually
happen when I just open a database for a short while and then close it...odd
eh?
I thought at first that it might be ZoneAlarm having a funny turn but as
I've uninstalled that I presume it must be something else.
Can you offer any explanation of why it does this?
TIA

Lee
 
A

Arvin Meyer

Access, itself, opens a single process: msaccess.exe, but many others can be
opened when using help, the IDE, any web services, Office and Office apps,
etc. Additionally, it is possible for VBA to not clean-up properly (like
when failing to explicitly close recordsets) and leave multiple processes
open. If you then re-open Access, you'll get duplicate processes.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top