Why is msado26.tlb missing

  • Thread starter Thread starter Laurel
  • Start date Start date
L

Laurel

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?????
 
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?
 
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.
 
Windows 2000 should have ADO on it, but it may not be the same version of
ADO that's on the development machine.
 
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?
 
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?
 
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.
 
Thanks 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.
 
One way is to download the compatibility checker and run it.
http://www.microsoft.com/downloads/...f6-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)
 
OK, 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?
 
As Brendon says, Install MDAC 2.8

Laurel said:
OK, 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?
Click to expand...
 
Back
Top