Access is on the "Memory leak blacklist" which can be found here:
http://www.radsoft.net/resources/software/reviews/blacklist.htm
I don't pretend to understand this phenomenon, but your symptoms fit their
description perfectly.
**********************************************************************
The problem is that as the user works in Access (entering data to a form
and saving it to the network database), system resources gradually drop off
and eventually a message pops up that the machine is short on memory. When
I check system resources, I find that they are at 2%(!!?). Killing Access
frees nothing, and a reboot is the only alternative. Then the process
starts again.
The NOSPIN Group Promotions is now offering
special "Free-After-Rebate" Software specials in conjunction
with Beyond.com. We have new offers all the time!!!
http://nospin.com/promotions