Compact & repair: With split db, do you c&r both the fe and be?

[jmuirman1]

Backend is on server, front end on desktop. should you compact & repair both and does it matter which db is C&R'd first?

When i repaired the last time, i did the be first followed by the fe and some buttons no longer functioned.

Thanks,

John

[isladogs]

Normally only the BE needs to be compacted as that is where all the data tables should be.
However if you use 'temporary' tables in the FE then you may need to compact the FE as well.

C&R shouldn't cause issues but corruption can occur...

Don't try and compact the BE whist anyone is using the FE.
Recommend you make a backup first just in case.
Also, switch off compact on close as it has been known to cause corruption.

[jmuirman1]

Perfect! Thanks for your advice!

John

[isladogs]

You're welcome