It is  suggested that you close your database after running the Compile All Modules command. The truth is, you'll probably want to close your database a couple of times during every work session (if your sessions are long).

When you call a function, Access opens the module that contains your code. Unfortunately, Access doesn't offer a programmatic way to close that module once you've run the procedure. That means you eventually end up with lots of modules open--and consuming memory--long after you need them. To free up memory used by open modules, simply close and reopen your database. (Don't exit Access; just close the database.) Doing so will close all your modules and free up the memory they would otherwise consume.

Access Index

Main Index