If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Leftover menu junk in empty DB
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 -- This e-mail address is fake, to keep spammers and their address harvesters out of my hair. If you need to get in touch personally, I am 'pdanes' and I use yahoo mail. But please use the newsgroups whenever possible, so that all may benefit from the exchange of ideas. |
Thread Tools | |
Display Modes | |
|
|