Why does compact and repair only compact the front end?

[ColinWard]

I don'tunderstand why when you use Compact and Repair, only the front
end is compacted? I understand about repairing, because the front end
stores the forms, queries etc. but the backend is where the data is
stored and surely that file will need to be compacted more than the
front end?

Colin

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Michael \(michka\) Kaplan [MS]]

You could have twn different linked tables that point to ten different
databases (not all of which may be available), so it is unrealistic for it
to compact everything. If you compact in the UI, it compacts the one you
have open in the UI.

For the others, you can compact yourself, programatically, if you want to.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"ColinWard" <je*********@hotmail.com> wrote in message
news:40*********************@news.frii.net...

I don'tunderstand why when you use Compact and Repair, only the front
end is compacted? I understand about repairing, because the front end
stores the forms, queries etc. but the backend is where the data is
stored and surely that file will need to be compacted more than the
front end?

Colin

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!