P
Petr Danes
Apologies for repeated posting, but I tried this in the CommandBarsUI group
and got no answers.
I have an Access 2003 database that has become quite slow to open and close.
I thought it was simply because I have several multi-level right-click
toolbars with many choices, but I'm beginning to suspect there is something
else wrong.
As an experiment, I tried gradually removing stuff from it, until I was left
with what appears to be an almost completely empty database. However, when I
create a new database, it is 96KB in size. This old one is 6222KB and is
still slow as molasses to open and close, even though to all appearances, it
is empty. I have removed everything I can see - tables, queries, code
modules, custom variables, toolbars (including the right-click ones, which
are not normally visible, even in the options dialog). I have run compact
and repair several times, no change. The only thing remaining, which is
probably causing the problem, is a set of hundreds, probably thousands of
things that look sort of like right-click menus.
When I go to View / Toolbars / Customize, Toolbars tab, Properties (I think,
I'm running a Czech OS here), it shows all the available menus and toolbars,
including the right-click one, which are not visible directly on the
Toolbars tab. In the top combobox there is the usual list of menus and
toolbars, but this bloated and slow empty db shows a huge list of
"Vlastní nabídka 10121031"
which is Czech for custom menu or some such. I don't know how many of these
things there are, the numbers start at 10120875 and end at 98518578, but
they do not jump by one. There are lots, though. My code deletes and
re-creates right-click menus, based on the contents of the database. Do the
RC menus leave behind some rubbish, as does a form when controls are created
and deleted? Is there a way to remove this trash? I've tried several VBA
routines for listing all custom menus and toolbars, both my own and copied
from the NG, none show this stuff.
I wanted to import the running database into a new, clean one, to improve
performance, but when I tried importing only what was left at one point, (I
thought, only a few custom toolbars, but, apparently, also this junk) the
new, previously empty database, swelled to 4300KB and also became very slow
to open and close. Whatever garbage is left in this old database, causing
the bloat and slowdown, gets imported into the new one when I import
toolbars, which defeats the whole purpose of the import.
When I tried another experiment, to create another new database and import
everything except the toolbars, the new database was about 2MB smaller,
24.3MB, down from 26.5MB, and it opens and closes immediately. Of course, it
doesn't work, because some of my code addresses the custom toolbars.
I'd hate to have to rebuild the toolbars manually, especially if this is
something I'm going to have to do regularly, or have to give up the
right-click menus, (my user loves them) but I'm sort of stuck. I haven't
been able to get hold of this junk and even if I could, deleting these
(probably) thousands by hand, one at a time, is not an attractive prospect,
especially if it's something that has to be done repeatedly.
Has anyone seen this before? I ran into a capacity problem recently,
deleting and re-creating controls on a form in code; I suspect these
toolbars may be causing a similar problem, but haven't found any references
to the subject.
I also looked in the registry and found several thousand references to these
same custom toolbars, but I don't know exactly what is what and am a little
hesitant to experiment there.
Petr
and got no answers.
I have an Access 2003 database that has become quite slow to open and close.
I thought it was simply because I have several multi-level right-click
toolbars with many choices, but I'm beginning to suspect there is something
else wrong.
As an experiment, I tried gradually removing stuff from it, until I was left
with what appears to be an almost completely empty database. However, when I
create a new database, it is 96KB in size. This old one is 6222KB and is
still slow as molasses to open and close, even though to all appearances, it
is empty. I have removed everything I can see - tables, queries, code
modules, custom variables, toolbars (including the right-click ones, which
are not normally visible, even in the options dialog). I have run compact
and repair several times, no change. The only thing remaining, which is
probably causing the problem, is a set of hundreds, probably thousands of
things that look sort of like right-click menus.
When I go to View / Toolbars / Customize, Toolbars tab, Properties (I think,
I'm running a Czech OS here), it shows all the available menus and toolbars,
including the right-click one, which are not visible directly on the
Toolbars tab. In the top combobox there is the usual list of menus and
toolbars, but this bloated and slow empty db shows a huge list of
"Vlastní nabídka 10121031"
which is Czech for custom menu or some such. I don't know how many of these
things there are, the numbers start at 10120875 and end at 98518578, but
they do not jump by one. There are lots, though. My code deletes and
re-creates right-click menus, based on the contents of the database. Do the
RC menus leave behind some rubbish, as does a form when controls are created
and deleted? Is there a way to remove this trash? I've tried several VBA
routines for listing all custom menus and toolbars, both my own and copied
from the NG, none show this stuff.
I wanted to import the running database into a new, clean one, to improve
performance, but when I tried importing only what was left at one point, (I
thought, only a few custom toolbars, but, apparently, also this junk) the
new, previously empty database, swelled to 4300KB and also became very slow
to open and close. Whatever garbage is left in this old database, causing
the bloat and slowdown, gets imported into the new one when I import
toolbars, which defeats the whole purpose of the import.
When I tried another experiment, to create another new database and import
everything except the toolbars, the new database was about 2MB smaller,
24.3MB, down from 26.5MB, and it opens and closes immediately. Of course, it
doesn't work, because some of my code addresses the custom toolbars.
I'd hate to have to rebuild the toolbars manually, especially if this is
something I'm going to have to do regularly, or have to give up the
right-click menus, (my user loves them) but I'm sort of stuck. I haven't
been able to get hold of this junk and even if I could, deleting these
(probably) thousands by hand, one at a time, is not an attractive prospect,
especially if it's something that has to be done repeatedly.
Has anyone seen this before? I ran into a capacity problem recently,
deleting and re-creating controls on a form in code; I suspect these
toolbars may be causing a similar problem, but haven't found any references
to the subject.
I also looked in the registry and found several thousand references to these
same custom toolbars, but I don't know exactly what is what and am a little
hesitant to experiment there.
Petr