stop access program database from growing

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

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
 
D

doglover

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