Compacting

A

alish

when i try to run compacting through macro it gives me an error. it tells me
do it manually. i added an additional command "CompactDatabase" into
QuitProgram macro. It is not working. Please help. THanks.
 
J

Jerry Whittle

What version of Access? If it's a newer version, you may be trying to
reinvent the wheel.

Go to Tools, Options, General tab and select Compact on close.

BTW: I highly recommend not doing this. Compact your database about once a
month manually. Unless your database is doing something bizarre such as
doubling in size daily, there is no good reason to compact so often.
 
A

alish

That is what needed. I am using Access 2003. We enter new data every week
and it doubles it's size but compacting is a good solution to that. Thanks.
 
Top