MSACCESS.EXE still in TaskMgr in Win2000

[DanP]

hi,

does anyone know why MSACCESS.EXE would still be listed in
the task manager even AFTER i close access? and is there
some command that i can set up with the scheduler so that
i can end the process in task manager? this causes major
problems for me as that instance of access prevents a new
one from starting.

any help would be appreciated...

thanks,
danp

 

['69 Camaro]

The MSAccess.EXE process will continue to run, even after you close it, if
your application is using a process that does not properly release system
resources. This sometimes happens when a VBA procedure fails to close a
RecordSet, then set the RecordSet variable to Nothing before the VBA
procedure loses scope. It can happen when using an explicitly defined
library function in a VBA procedure that does not complete its execution
before the application ends. It can also happen when a Form is using a
user-defined function to dynamically fill a ListBox or ComboBox.

You'll need to hunt through the application's code to determine what is
holding onto system resources when the application ends.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Tony Toews]

does anyone know why MSACCESS.EXE would still be listed in
the task manager even AFTER i close access? and is there
some command that i can set up with the scheduler so that
i can end the process in task manager? this causes major
problems for me as that instance of access prevents a new
one from starting.

Access minimizes to Windows 95/NT toolbar instead of closing
http://www.mvps.org/access/bugs/bugs0005.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm