stop access program database from growing

[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.

 

[Nikos Yannacopoulos]

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

 

[doglover]

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