My DB is split into BE and FE. I have linked the tables. When I use Compact and Repair from FE, it only compacts FE and not the BE. Is it possible to compact the BE from FE? If so, would be grateful for help on code.
You would have to do this in code and it would only be achievable if you there were no other users logged in to the back end database. The easiest way to do this is to open up the back end and set the compact on close to true in the general options settings.