Why is msado26.tlb missing

Why is msado26.tlb missing

Post by Laure » Fri, 08 Apr 2005 21:35:45


I have an Access 2000 database that was developed on Windows XP, and runs
find on other XP systems. But when we tried to run it on a Windows 2000
system, we got a reference error for msado26.tlb. I can't be sure that this
is because the OSs differ - don't have that many computers to play with.
Anyway, I was never aware of specifically getting ADO code. (Is that what
you call it? "code?"). Why would the 2000 computer not have it? We did a
search and the file is definitely not there. What can I do about it?

Oh. At least one of the XP PCs is running XP Professional. I don't know
about the other. Could that be it?????
 
 
 

Why is msado26.tlb missing

Post by DL » Fri, 08 Apr 2005 22:22:54

You may need to update MDAC
http://www.yqcomputer.com/
also the Component checker utility can be usefull
http://www.yqcomputer.com/



this
a

 
 
 

Why is msado26.tlb missing

Post by Laure » Sat, 09 Apr 2005 02:27:09

Thanks I'll look into this.
But I also want to understand what's going on. Do I understand correctly,
then, that the ADO components (code? ...what's the right word), *ought* to
be found on a Windows 2000 system, by default? Well, anyway, that this file
ought to be found on a Windows 2000 system?
 
 
 

Why is msado26.tlb missing

Post by DL » Sat, 09 Apr 2005 07:14:05

ADO - ActiveX Data Objects -
Afraid I'm unable to access msdn.microsoft.com at this time;
From recollection this is part of the MDAC update/installation, which is in
turn updated/supplied with certain core MS Apps (Win2k, WinXP, Access eg?)
ie if you use Winupdate, any update to MDAC should be shown on none critical
updates.
I seem to also recall that any jet update is no longer part of a MDAC update
Your missing file is certainly on my sys, Win2k + Access2K + MDAC v2.7
refresh

If you are distributing an Access runtime, which was developed on a
different sys, you may well have to ensure that MDAC on the proposed host is
updated. As I understand it allthough MDAC should be backward compatible
your build may include the use of dll's that have added functionality, not
available on the host sys MDAC.
Leastways when I distributed a Delphi runtime, using an Access backend db, I
had also to distribute an updated MDAC.
Hope this is helpfull.



to
file




runs
2000
with.
know
 
 
 

Why is msado26.tlb missing

Post by Douglas J. » Sat, 09 Apr 2005 07:32:29

Windows 2000 should have ADO on it, but it may not be the same version of
ADO that's on the development machine.

--
Doug Steele, Microsoft Access MVP
http://www.yqcomputer.com/
(no e-mails, please!)
 
 
 

Why is msado26.tlb missing

Post by Laure » Sat, 09 Apr 2005 12:15:37

I think it might be helpful.... What does MDAC stand for?
 
 
 

Why is msado26.tlb missing

Post by Laure » Sat, 09 Apr 2005 12:18:00

Thanks. It looks like you've given me the same URL (for the checker
utility) both times. Could you give me the URL for the actual update?
What does MDAC stand for?
 
 
 

Why is msado26.tlb missing

Post by DL » Sat, 09 Apr 2005 17:02:05

http://www.yqcomputer.com/
http://www.yqcomputer.com/
MDAC: Microsoft Data Access Components







runs
2000
with.
know
 
 
 

Why is msado26.tlb missing

Post by Laure » Sun, 10 Apr 2005 10:44:21

There are lots of downloads there. Is what I want MDAC 2.8? It talks about
servers and ODBC and stuff. This is what contains the ADO components?
 
 
 

Why is msado26.tlb missing

Post by DL » Sun, 10 Apr 2005 19:58:12

Asertain the MDAC version on the development sys, then download/install the
same version on the host sys.
You can install latest version 2.8 as it is backward compatible with erlier
versions.
Personally I've never had a problem installing a later version, and
functionality with my Access db.



about








that
We
it?
 
 
 

Why is msado26.tlb missing

Post by Laure » Sun, 10 Apr 2005 22:15:28

hanks for all your help. I don't know what "MDAC" is, so I don't know how
to figure out the version I have on my system. I barely understand the
rules for making ADO and DAO references. Could you give me steps for
finding out what MDAC I have on my system? Although, from what you say, it
sounds like it would be OK to use 2.8. I didn't see anyplace to get 2.7 on
the web site.


"DL" <dl@spoofmail> wrote in message
news: XXXX@XXXXX.COM ...


 
 
 

Why is msado26.tlb missing

Post by DL » Sun, 10 Apr 2005 23:18:32

ne way is to download the compatibility checker and run it.
http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en
or
http://msdn.microsoft.com/data/mdac/downloads/default.aspx
All the versions of MDAC can also be downloaded from the above page.

MDAC - MS Data Access Components - is a core component of a number of MS
apps.

You could also try running winupdate,on the host sys, and checking if it
shows any updates under 'None Critical'. Also run MS Office Update (Can be
accessed from the winupdate page)

"Laurel" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
it
on
components?
update?
Windows
sure
play
it?


 
 
 

Why is msado26.tlb missing

Post by Laure » Tue, 12 Apr 2005 10:37:23

K, I ran the compatibility checker. It tells me I'm on MDAC 2.8, SP1, XP
SP2.
Then I ran an analysis on all of the 2.6 releases and on 2.8 SP1 on Windows
XP SP2, and in none of the lists of files each analysis displayed did I find
my missing msado26.tlb. In fact there were no *.tlb files in any of the
lists. So does this mean that it won't help to install one of these
releases on the deficient Windows 2000 machine?

Also, you or someone suggested I find out what is on my machine, and install
that on the 2000 machine. But I wouldn't want to install something called
'MDAC 2.8 SP8 on Windows 2000 SP2 would I?


"DL" <dl@spoofmail> wrote in message
news: XXXX@XXXXX.COM ...


 
 
 

Why is msado26.tlb missing

Post by Brendan Re » Tue, 12 Apr 2005 17:54:58

heck this page ...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;828396

msado26.tlb is included in MDAC 2.8, and Windows 2000 is supported.

--
Brendan Reynolds (MVP)


"Laurel" < XXXX@XXXXX.COM > wrote in message
news:% XXXX@XXXXX.COM ...


 
 
 

Why is msado26.tlb missing

Post by DL » Tue, 12 Apr 2005 21:25:35

s Brendon says, Install MDAC 2.8

"Laurel" < XXXX@XXXXX.COM > wrote in message
news:% XXXX@XXXXX.COM ...
Windows
find
install
http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en
be
say,
2.7
download/install
talks
XP,
(Is