Access process will not close

[Robert Ross]

I've got a split database (front end on the user's hard
drive, back end on the network). When users close the
database, the program closes (checked the Task List under
Applications, the program disappears), but the program
remains active in the Processes tab. I've used the
QuitApp, Close buttons, etc. but nothing seems to work,
and it's only on this database...others seem to work just
fine.

Any ideas?

THX!

 

[Van T. Dinh]

One of the common cause of this behaviour is that Access creates objects in
the memory but does not destroy the object after use and therefore Access
can't close.

If you open any objects such as Database Object (using CurrentDb) or
Recordset Object, make sure you Close the Objects after use. For all Object
Variables, make sure you set them to Nothing after use.