Gerard, how much code do you have in the Database. If you are using A2000 and probably 2002, Access loads ALL the code modules when you open one and it drains memory like nothing I've ever seen. If you want a clear demonstration, open any Module. Then go to Window on the menu bar and look at all the modules you have open. If you have many, you will see a little "More Windows" dropdown list. It's quite unbelieveable. I have 256 on my home machine and when I have some of my test db's open, it's not enough.
Paul