Compact an Access 2000 database within a macro

[ricky.kimball]

I have an application (processing.mdb) database with most table linked
to another access database (data.mdb) I delete from interim processing
tables as I'm finished with them, but data.mdb gets too big and I need
to compact it. I'd like to add a command within a macro in
processing.mdb that will compact data.mdb after each delete from a
table.

 

[Guest]

I don't recommend you do that as there will be a delay and the user may not
be happy with that. There is an option do do a compact on close. Check out
the tools menu. If you are creating and deleting huge temporary tables very
often that indicates a poor design.

Dorian

 

[Guest]

Please quantify "too big" in the size of the MDB file in MB or GB.