Self Compressing

[Rudy W.]

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

 

[Andi Mayer]

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

compact means closing, therefore your aproach will not work

 

[Dirk Goldgar]

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

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