Erik Sojka (MVP) shared these words of wisdom:
[...] MS' database technology is pretty good about keeping the
inside of a database file optimized, and will fill in whitespace
before expanding the file size.
Let's hope and pray ;-)
I've learnt my lessons in early Access (2.0) ... [siiiigh]
What would I have given for having the old scheme of separate files
for the tables like in good old dBASE - even at the price of the
database being rather vulnerable like with the Paradox system with
it's separate index-files ...
[compacting] ...
Options | Other and clicking "Optimize All Files Now".
[...]
Trying a good guess on the naming, I assume that this would be
the forth item in the "Options" menu, the German wording of
which ("Dokumentenverwaltung") might be translated to
"administration of documents" (which does not really make
sense; seems I have to file a translation bug).
That might be the location in the dialog box.
In English it appears as "Optimizing Section Files"
- sounds similar to "administration of documents"
Not really. But it seemed to come close
The button to optimize all files should be immediately
above the button which says "Install OneNote Mobile..."
I had already put a posting with a a cry for help in the outbox, but
checking everything for 13th time or so <g> I got it. We had been
talking about different things.
From your noation "Options | Other" I had thought that you were
referring to an item in the root of the menu-system and looked under
"Extras" (thinking to remeber that it was called different in English)
and there I had found the inoperable menu-item "Dokumentenverwaltung"
which does nothing.
But now I found the Button "Alle Dateien jetzt optimieren" meaning
"Optimizing all files now".
This one works. I had put back the 42MB monster. It was optomized to
946KB.
Great.
Thanks a lot for that pointer.
But as we are at it:
IMHO this feature is too well hidden.
The way the "Others" item in the "Options" dialog is et up, to me it
seems as if somone has put everything swept together just in there.
The layout of this dialog IMO is not constistent with the way dialogs
for "settings"/"options" normally are built in Windows and Office
applications. And with the lessons I have learnt on GUI-design and it
logics it does not harmonize too well to have tools/features (like
installing on mobile device and optimizing data) to be executed deep
down there and this in a window which is to small to show it all and
therefore needs a scroll-bar [siiigh].
There were days when StyleGuides were something to be respected and
followed and developers were not just placing whatever they liked at
whatever place coming into their mind <bg,d&rvf>. Seems long gone
:-( :-(
Thanks again for your help.
The feature is built in and I'm glad to see that and how it works.
Rainald
P.S. The menu item under "Extras" "Administration of data" which I had
been talking about indeed is not doing anything. And I have no idea at
all what it might be good for :-(