By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,761 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Why does compact and repair only compact the front end?

P: n/a
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!
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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!

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.