Compact back-end database

[Michael]

Hi Folks - Question ... I have a FE and BE Access 2000 database
configuration. If I choose the option to compact on close for the BE
database, will it be compacted, or do I need to explicitly open and close
the BE db. If so, what techniques are people using to automatically compact
the BE db? Thanks.

Michael

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

Hi Folks - Question ... I have a FE and BE Access 2000 database
configuration. If I choose the option to compact on close for the BE
database, will it be compacted, or do I need to explicitly open and close
the BE db. If so, what techniques are people using to automatically compact
the BE db? Thanks.

Michael

Michael,

The compact on close only work when the Access EXE file open the database
and then closes it. It codes not work on a back end when the front end closes.


I normally do not use the compact on close. I find it best to backup a
database before the compact/repair is run.

Also yo can not compact a back end will there are in users the front end is
accessing it.

I like to use a scheduled task to ZIP and compact each back end.
Here is an example: http://www.peterssoftware.com/cal.htm