Results 1 to 11 of 11
  1. #1
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: ADO Help Files (2000 SR-1)

    We've seen some really strange behavior with MDAC 2.7 so we tend to avoid it like the plague. I'm surprised that it would clobber the Help files however. I should note that I have similar behavior with Access XP - the help files for ADO and DAO are virtually worthless. I resort to using help on my laptop which as Access2k and get the syntax I need from it. Anybody else out there with horror stories on Help?
    Wendell

  2. #2
    Lounger
    Join Date
    Jan 2001
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ADO Help Files (2000 SR-1)

    You're able to get ADO help in Access 2000? Which release of Access is it? I now realize my problem getting the help files was present before I installed MDAC 2.7. I've tried copying the help files manually, and can open the help manually, but we were hoping to restore the context sensitive ADO help.

    Thank you again.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: ADO Help Files (2000 SR-1)

    The help for Access 2000 has some definite foibles - it seems if I start a simple ADO routine, and I type
    <font color=448800>Dim cnn as New ADODB.Connection</font color=448800>
    then highlight ADODB and press F1, I get "No help available" from a VBA dialog box. On the other hand if I highlight Connection and press F1, I get a Context Help dialog box which asks whehter I want to see Access Connection help or ADODB Connection help. As you probably know, Access 2000 was the first version to support ADO. I think the general concensus is that it was sort of a work in progress - there were still lots of things that were either difficult or impossible in ADO that DAO could easily handle. That being the case, the help files were bound to be a bit iffy.

    And indeed, in Access 2002 (XP) they have improved the ADO capabilities considerably. Unfortunately, the help files seem to have retrogressed. If I type the same line in VBA, I don't even get builder help on ADODB, and if I press F1 on Connection, I get an Access and a DAO help choice. The Access one takes me to the entire Access Object Collection help, and the DAO one doesn't do anything. It appears to me that much of the help that was available for VBA in Access2000 is entirely missing. I should note that I have not installed SP1 for Office XP, so that may fix some things. I guess the bottom line is if you are frustrated with 2000, then avoid 2002.
    Wendell

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ADO Help Files (2000 SR-1)

    Help in Access 2000 seems highly breakable, although I don't think it has much to do with Access but is an Office/Help/Windows problem. I keep Access 97 on my machine and resort to it at times. I csn usually get help to come up in A2k (except when I hit F1 from the Object Browser, which used to work) but I can't get to most of the articles listed when I use thw Answer Wizard, and those (primarily the DAO and ADO stuff) are the items I need. Oddly enough, if I type the topic I see listed into the Answer Wizard search box, it will usually bring up that topic!!

    I've found that installations of other products (not even Microsoft products) can trash my Access/Office/VB help files, although the VB help files seem to be the most resiliant. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  5. #5
    Lounger
    Join Date
    Jan 2001
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ADO Help Files (2000 SR-1)

    I followed the steps that Rory mentioned in <!post= Post 45163,45163> Post 45163<!/post>, however I am still getting blank help screens whenever I hit F1 on something to do with ADO. I set the registry like the post mentioned, but it seems to be lost in space. I recently downloaded MDAC 2.7 if that helps someone understand what's happening.

    Can someone tell me what's going on?

    Thanks kindly in advance

    Edited by Charlotte to activate link to post

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: ADO Help Files (2000 SR-1)

    When I (briefly) had MDAC 2.7, I too found that help didn't work. If I changed the reference in my project back to 2.1, I found that help then functioned OK. Can't recall off the top of my head whether the same was true of 2.5 and 2.6 and I'm in the middle of a reinstall on my PC so can't check at the moment. The problems only started for me when I upgraded to Win2k - on NT 4.0 everything was OK.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ADO Help Files (2000 SR-1)

    I've had problems with 2.6 and stayed away from 2.7. Unfortunately, SQL Server 2000 installs 2.6, so I'm stuck with that. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ADO Help Files (2000 SR-1)

    I don't know if you remember but I brought up this question about 18 months ago and finally found an answer...thanks to Rory who speaks later in this thread but does not mention his solution...http://www.wopr.com/cgi-bin/w3t/showthread...mp;Number=45163

    I also, basing it on the above worked out how to get the
    DAO help working as well ..

    My reply is slightly tardy too as I have just returned from a holiday in France wishing I were still there...
    Your reply is the only one that has hit the nail on the head! Yes it works and my first suspicion that it is Windows 2000 that messed up the HTML help of
    Office 2000 proves to be correct. Others kindly replied with surmises and general answers which weren't correct but your solution is apposite and right to the point! Thanks!
    The wonder is that so few have stumbled on this defect
    (it is an outright error) of Win2000 not installing the full Office 2000 help files. I personally find the Visual Basic help really useful in devising solutions and it was annoying me to have to leaf through textbooks to dredge up the answers. Now ADO (help) works fine.
    Moreover I have made a few changes to your ADO solution to come up with one that gets DAO 3.6 help working too (which also didn't function correctly).
    Copy the file DAO360.CHM from the Office installation disc found in this location:
    PfilesCommonMSSHAREDDAO
    to
    Program FilesCommon FilesMicrosoft SharedDAO
    (usually on C<img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    and edit the registry key dao360.chm
    (it was already there in my setup, otherwise create it)
    in
    HKLMSOFTWAREMicrosoftWindowsHTML Help
    ensuring the string value is
    C:Program FilesCommon FilesMicrosoft SharedDAO
    Reboot and BOB'S YOUR UNCLE!
    Now, are there are other sections apart from these two
    that don't work for similar reasons AND will the issue
    be all fixed up in OfficeXP?
    >>>>>>>>>>>>>>>>>
    But there are still those annoying blank help screens from time to time albeit less frequent.

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ADO Help Files (2000 SR-1)

    I find the OXP Help to be worse, not better, than the 2000 version. <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>
    Charlotte

  10. #10
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: ADO Help Files (2000 SR-1)

    AMEN! Running OXP on either WinME or Win2000 doesn't seem to make any difference either. Haven't tried WinXP so can't comment on it.
    Wendell

  11. #11
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ADO Help Files (2000 SR-1)

    I have AccessXP SP-1 installed on W2k and when I did your test from previous post I got no help available on the ADODB keyword and a choice on connection keyword. The choice was Access - which you got - and an ADODB library choice which leads to the page for the connection object. Just FYI.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •