PDA

View Full Version : Access 200 VBA Help freezes



tbacon_nz
02-06-2004, 11:17 PM
When I try to open VBA Help in Access 2000, I get a blank window with "Microsoft Visual Basic Help" in the title bar, but nothing else and which won't respond to anything. All I can do is kill the task. I've tried:

"repairing" Office 2000 - no diff.
Uninstalling and reinstalling the help components of Access - no diff.

The next thing is to un/reinstall Office, but I don't want to do that if I can avoid it.

Any ideas? If anyone can tell me the filename of the Access 2000 VBA help file, I can see if it actually exists.

TIA

Tony Bacon

tbacon_nz
02-06-2004, 11:18 PM
edit - subject is Access 2000

beama
03-06-2004, 12:20 AM
have you got those help files installed
got add remove applet in control panel high light microsoft office click on button change botton click on add/remove features check (and add) which features you have installed you may not even have vba support in access (installed) I think you will find it in vba help in the area of "office shared features" mines set to install on first use

beama
03-06-2004, 12:22 AM
shame on me for that last post I should proof read

wuppo
03-06-2004, 12:38 AM
Well known problem :|

http://support.microsoft.com/default.aspx?scid=kb;en-us;249065

tbacon_nz
03-06-2004, 01:18 PM
Thanks wuppo, but I think I have a different problem. I applied the fix you pointed me to some time ago, and all the files are in the correct folders.

I did a check, and if I go Help|VBA help I either get the freeze, or sometimes after a very long time, the initial help screen appears. If I click on a keyword in some code and press F1, I (eventually) get the context help. However once that has appeared, the usual help appears more quickly.

I was trying to find out about ADO, and if I put ADO in the index search, I get a list of topics, but when I click one, nothing happens. If I go to the contents, I can't find anything referring to ADO in the methods or properties.

Looks like a missing/corrupted file to me - but what and where?

(sigh) - it also appears to be inconsistent. Just now it worked, then it didn't, then I just got a dialog "unable to diplay help" (not the message in the MS KB article).

Doesn't this sort of stuff drive you nuts?

Dolby Digital
03-06-2004, 02:39 PM
>>Doesn't this sort of stuff drive you nuts?
Yep.

What version of Windows are you running. Its a long shot, but if you are behind in Service Packs, installing them might help. Have you done a Scandisk and all that jazz, yes, maybe you have a corrupted file.

tbacon_nz
03-06-2004, 03:28 PM
If only it were so easy! :-(

Windows and Office is all up to date.

No disk errors that I can find, Norton tells me I have no problems.

It has to be some sort of Registry/file link problem. There is an ADO help file in the right place (Ado210.chm) which opens OK if you double-click it directly, but Access obviously can't find it. It has an index to it (entries show up when I index search on ADO), but it can't find the details.

Grrrh!

Dolby Digital
03-06-2004, 06:53 PM
Can you go into VBA in Excel and see if you can get help up? Aren't Microsoft supposed to support their applications... they can fix it :)

Dolby Digital
03-06-2004, 06:55 PM
Call yourself a programmer, real programmers don't need on-line help :)

parry
03-06-2004, 09:12 PM
Hi Tony, you seemed to have tried everything else so downloadRegsvr32.exe (http://support.microsoft.com/default.aspx?scid=kb;EN-US;161983) to manuallyregister components.

Im not sure if you can register a chm file as Ive only used this with dll/ocx files. Perhaps look for a dll/ocx with ado in its name if registering the chm doesnt work.

Ive got Access 2002 but these are my hits in the reg when searching for ado210.chm.

HKEY_CLASSES_ROOT\Installer\Components\71CE92CC2CB 71D119A12000A9CE1A22A
Name: 1033\ado210.chm
Type: REG_MULTI_SZ
Data: C84DVn-}f(YR]eAR6.jiVBAHelpFiles>!V1Z3_Aaq@~+)dq.m0mh

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Comp onents\71CE92CC2CB71D119A12000A9CE1A22A
Name: 1033\ado210.chm
Type: REG_MULTI_SZ
Data: C84DVn-}f(YR]eAR6.jiVBAHelpFiles>!V1Z3_Aaq@~+)dq.m0mh

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Installer\UserData\S-1-5-18\Components\4DEC1803B38555D49BEDE22EE

C74386C
Name: 9040820900063D11C8EF00054038389C
Type: REG_SZ
Data: C?\Program Files\Common Files\Microsoft Shared\Office10\1033\ADO210.CHM

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\SharedDLLs
Name: C:\Program Files\Common Files\Microsoft Shared\Office10\1033\ADO210.CHM
Type: REG_DWORD
Data: 0x00000001(1)

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\HTML Help
Name: ado210.chm
Type: REG_SZ
Data: C:\Program Files\Common Files\Microsoft Shared\Office10\1033\

HKEY_USERS\S-1-5-21-3548030889-936017620-2587665221-1005\Software\Microsoft\Search Assistant\ACMru\5603
Name: 000
Type: REG_SZ
Data: Ado210.chm

Best of luck. :-)

tbacon_nz
04-06-2004, 10:58 AM
Well, waddyaknow! :D

Parry, I applied the registry changes you listed - modified for my environment, and now it nearly all works! I certainly get access (ha ha) to ADO-type references when using index search on VBA Help. What I don't get is context-sensitive help if I F1 on an ADO keyword in the actual code. Then I still get the blank help window - but I can live with that.

I'm picking that the key registry entry was HKEY_LOCAL_MACHINE...SHARED DLLS etc.

I couldn't get regsvr32 to do it for me. I just got "the specified module could not be found" - however I structured it.

Thanks everyone for their contributions - any other ideas would still be welcome.

Tony Bacon

parry
04-06-2004, 12:16 PM
Hi Tony, glad your making progress. :-)

I believe that error is because you either havent navigated to the folder that contains the regsvr32 file before using the exe or you have entered the incorrect path for the target. I see there is an ADO Aw (Answer wizard) file - try registering that one.

Presuming you stored the regsvr32 file in C:\Downloads and the target file is ADO210.AW

eg
CD c:
CD C:\Downloads
Regsvr32.exe "C:\Program Files\Microsoft Office\Office10\1033\ADO210.AW"

tbacon_nz
04-06-2004, 04:34 PM
Hi Parry,

Good news and bad news. Regsvr32 definitely doesn't do it. I must have had a path wrong before but this time I got "ADO210.AW is not an executable file and no registration helper is registered for this type." Same for ADO210.CHM.

However I made sure the .AW file was in the same folder as the CHM, and things seem to be working, albeit a bit flakily. I think I am at the stage where near enough is good enough. If I discover anything else I'll post again.

Thanks for all your help.

Tony Bacon