Compacting database?

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

Guest

Is there VBA code I can use when quiting my application that will compact my database? Thanks.
 
in Access2000 and newer, you can set a db to compact automatically when it
closes.
open the database window.
on the menu bar, click Tools, Options.
on the General tab, checkmark the box next to Compact on Close.

hth

Ken said:
Is there VBA code I can use when quiting my application that will compact
Click to expand...
my database? Thanks.
 
Back
Top