Compact & Repair Question

[Guest]

i have a FE & BE database. Both databases are set to compact on close via the
tools-options-general tab.

This doesnt appear to work on split databases? any ideas on a way round this?

 

[Pieter Wijnen]

check http://www.mvps.org/access

Pieter

i have a FE & BE database. Both databases are set to compact on close via
the
tools-options-general tab.

This doesnt appear to work on split databases? any ideas on a way round
this?

--

 

[John Vinson]

i have a FE & BE database. Both databases are set to compact on close via the
tools-options-general tab.

This doesnt appear to work on split databases? any ideas on a way round this?

The backend will only compact when the LAST frontend disconnects from
it. If user A closes her database but users B, C and D have it open,
it will detect that the database is in use and not attempt to compact.

There is probably little benefit from compacting the frontend.
Normally the frontend won't contain any tables in any case! It may
bloat somewhat from queries and Microsoft-generated temp tables, but
it can be simply replaced with a new copy of a "fresh" backend as
needed.


John W. Vinson[MVP]