stop access program database from growing

  • Thread starter Thread starter doglover
  • Start date Start date
D

doglover

How do you stop the program database from growing each
time it is opened. I have created a switchboard to work
off of(using forms). I understand that if any of the
forms (program database) are opended then they need to be
debugged and the database compacted. There must be a way
to prevent the database from growing from normal work. I
guess the program database is fragmenting because
compacting reduces it. The program database is linked to
another database which stores the data files.
 
Tick the Compact On Close box on the General tab under Tools > Options. This
will result in the database being compacted every time you exit, so you
start with a compacted one every time you open it.

HTH,
Nikos
 
My database does not have the Compact on Close box option
(tools, general tabl, options,). Using Office 97
Professional version.
 
Back
Top