Compact Database

D

djh

In Access 97, is there a way in VBA to do a compact of the open database, so
that the space from deleted records is recovered, as can be done with the
Tools-Database Utilities' menu option? When my form's Exit button is
clicked, I would like to do this and then exit.
 
N

Neily

I'm not sure about Access 97, but in the Tools and then Options menu of
Access 2000, on the General tab, you can check a box which makes Access do a
Compact and Repair automatically on exit.
 
D

djh

I don't see that option in Access 97, but I don't want to do it for all
databases, just for this one database and from exiting this one form from
which various extracts can be generated.
 
D

Douglas J Steele

Take a look at the TSI SOON (Shut One, Open New) add-in MichKa has at his
site.

The site is http://www.trigeminal.com/, but unfortunately it appears to be
down at the moment, so I can't give you a specific URL for the add-in. If I
remember correctly, the first choice on the page is Utilities, and it's
under that.
 
L

Larry Linson

"Douglas J Steele" wrote
Take a look at the TSI SOON (Shut One, Open New) add-in MichKa has at his
site.

The site is http://www.trigeminal.com/, but unfortunately it appears to be
down at the moment, so I can't give you a specific URL for the add-in. If
I
remember correctly, the first choice on the page is Utilities, and it's
under that.
Click to expand...

Looks like it is back up, and he also has a "Compactor" in the same list as
TSI SOON, which might be worth a look. Well, _anything_ of michka's is
"worth a look", but this might be just what the original poster needs.

Larry Linson
Microsoft Access MVP
 
Top