Can't install ADO 2.1 in Excel 2000?

[Paladyr]

When I got to references and try to add Microsoft ADO 2.1, it doesn't give me that option. On this link though, it says that I should be able to install it:

http://www.microsoft.com/office/ork/2000/one/10t3_3.htm

It says, and I quote: "You can install the OLE DB components and ADO 2.1 with Office 2000. "

Any ideas on why I can't install it or how I can get it installed??? Thanks!

 

[Paladyr]

Does anyone know if I am supposed to be able to do this??? I'm thinking that because I don't have VB installed (comes with a developer's license) I can't use these controls. Does that sound right??

 

[CodeFish]

Hi Paladyr,

Yes you should be able to. The reason you can't is either you haven't got ADO 2.1 installed on your machine (likely)or it is installed but not referenced.

Search your harddrive for the dll - msado21.tlb if it exists you need to register it using regsvr32.exe in the RUN option of the Start Menu in Windows.

in the form:-

regsvr32 PATHNAME OF msado21.tlb

e.g. regsvr32 C:\Program Files\Common Files\System\ado\msado21.tlb

Restart the computer and you should now find the ADO 2.1 available.

If you can't find msado21.tlb then goto Micosoft's site and download it from there (found in a setup package called MDAC.exe).

ADO 2.6 is freely available now, so you are best getting hold of this newer version of ADO if you can. The dll - msado15.dll

Hope this helps,

Codefish

 

[Paladyr]

Thank you for your reply! I have already done that for ADO 2.1 as well as ADO 2.5. I was always able to add each of them under references, however it looked different from when I added it inside Visual basic 6.0 on my home computer (I am currently trying to do this on my computer at work). Instead of it appearing as ADO 2.5, it says "Microsoft ActiveX Data Objects 2.5 Library", so I think it is the VBA truncated version of it. I'm pretty sure I have to have a developer's license (VB 5 or 6) installed to use the additional controls I am interested in (like the ADO data control). I read on microsoft's website that VBA does limit what controls you can use so I think that is the problem. I don't think I made it clear in my post exactly what I was trying to do. When I said I couldn't install ADO 2.1, I meant it wasn't letting me install the "full version" because the only thing I was able to install was "Microsoft ActiveX Data Objects 2.1 Library" which was different from what I had installed in the past, where it had "ADO 2.1" in the text of the reference. Does that make sense?

Also, what the heck does installing ADO 2.5 do because it doesn't appear as if it gave me any additional controls??? Does it just give me some different options while coding??? Thanks again for the reply!