After Splitting the database

[accessfleet]

Once a database has been split how often should it be compacted?

Do you compact both the FE and the BE or is one mere important than the other?

 

[ghudson]

Since the front end should be on the users computer you can turn on the compact on close option for the front end. Compacting really depends on what you are doing with the data and how large the db bloats after you import data, delete data, etc.

 

[accessfleet]

So, Compacting the fe is frequent and compacting the be is occasional?

 

[DCrake]

Personally I would reverse that assumption. Compacting the data tables improves efficiency so doing it regulary is more prudent. If your front end bloats then something must be happening locally for this to do that. Setting compact on Close as suggested will kep this down and does not involve user intervention. Remember you can only compact a back end if no users have it open.

 

[accessfleet]

Now That's the kind of information that helps me to figure out the right thing to do.

thanks..

John.