Compacting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
Back
Top