Self Compressing

  • Thread starter Thread starter Rudy W.
  • Start date Start date
R

Rudy W.

What is the VBA code to make a database compress itself
(before going on with other memory consuming activities)?
 
What is the VBA code to make a database compress itself
(before going on with other memory consuming activities)?
Click to expand...

compact means closing, therefore your aproach will not work
 
Rudy W. said:
What is the VBA code to make a database compress itself
(before going on with other memory consuming activities)?
Click to expand...

Memory isn't the issue; disk space is the issue. If you have Access
2000 or later, you can get the database to compact itself without the
use of any external routine, but if you are using Access 97, you need to
pass control to an external module of some sort to close, compact, and
reopen the database. See this link for how to do it either way:

http://www.mvps.org/access/general/gen0013.htm
 
Back
Top