Microsoft Dao 2.5 3.5 Compatibility Library Download

Klaudia Kominski <[email protected]> Tue, 5 Dec 2023 09:17:43 -0800 (PST)
Newsgroups alt.autos.nissan
Message-ID <[email protected]>
microsoft dao 2.5/3.5 compatibility library, microsoft dao2.5/3.51 compatib=
ility library, missing microsoft dao 2.5/3.5compatibility library, microsof=
t excel 16.0 object librarycompatibility, microsoft printer compatibility l=
ibrary, microsoftprinter compatibility library 1.0

If you are wondering which objects should be disambiguated in VBA code when=
 a database application references both the DAO and ADO libraries, I have a=
 few files included in a Zip archive that you may download here. I have inc=
luded an Access database which contains a table storing the name of each me=
mber of the DAO 3.6 Object Library and the ADO 2.1 Object Library, includin=
g the hidden members. The database also contains a query named "Find duplic=
ates for tblADO_DAOObjects." Object names that are present in the recordset=
 of this query should be disambiguated with either ADODB or DAO as a part o=
f the declaration statement in VBA code, so that one does not have to worry=
 about object library priority issues. I have also included an Excel spread=
sheet listing all of the members of the DAO 3.6 and ADO 2.1 object librarie=
s, including the hidden members, for handy reference.

microsoft dao 2.5 3.5 compatibility library download
Download File https://jinyurl.com/2wItE5



Hi All,=20
 I have a small database program originally written in Access 95. It ran=20
 with very little if any modification of the code, until I tried to remove=
=20
 the old administrative install (on the network drive) of Office 97.=20
 Right after that, the program crashes because of a missing reference. The=
=20
 missing reference is "MS DAO 25. 3.5 Compatibility Library." This is a fil=
e=20
 in the old Office 97 folder.=20
 I was able to restore all the old data, and get the program running again,=
=20
 but of course I would like to eliminate the reference to the old library a=
nd=20
 bring the code up to date.=20
 Unfortunately, I've forgotten what little Access coding that I learned for=
=20
 that project, and I'm not sure how to proceed. I notice that there is a=20
 help page that mentions unsupported commands with DAO 3.6 and suggests=20
 replacements, but I don't think I'm using any of the older commands,=20
 although I'm using commands of the same type.=20
 I've tried to create a new Access 2000 database, import all the forms and=
=20
 recompile, but running the form gives me a "Compile Error Method or Data=
=20
 Member not found" on 'gUpdateMonth =3D Updateset.UpdateMonth'=20
 I would apreciate a bit of guidance here. Do I need to go learn the new=20
 methods and manually rewrite the code?=20
 Thanks=20
 Jim Helfer=20
 WTW Architects=20
=20
 Sat, 14 Aug 2004 06:28:56 GMT Chris Mill
#2 / 7 MS DAO 2.5/3.5 compatibility Library Any code module, Tools, Referen=
ces, remove the missing reference and check any=20
 recommended DAO library should do it.=20
 Though there are different versions of DAO libraries, just checking an=20
 available one in the References list will usually do it. They are bug fixe=
s=20
 and not really code alterations, as far as I know.=20
 DAO 3.51 appears to be the standard DAO library for A97. I've no idea what=
 it=20
 was for A95, and you'll be hard-pressed to find anyone with experience of =
A95=20
 here. By all accounts, it was a dog and most people morphed into A97.=20
 It's not really clear what you have, "A95 and removing an administrative=
=20
 install of O97". I suggest you remove everything, then decide exactly whic=
h=20
 version of Office/Access you actually want to install. Few would argue aga=
inst=20
 A97 being better than A95.=20
 Chris=20
=20
 Quote:> Hi All,=20
 > I have a small database program originally written in Access 95. It ran=
=20
 > with very little if any modification of the code, until I tried to remov=
e=20
 > the old administrative install (on the network drive) of Office 97.=20
 > Right after that, the program crashes because of a missing reference. Th=
e=20
 > missing reference is "MS DAO 25. 3.5 Compatibility Library." This is a f=
ile=20
 > in the old Office 97 folder.=20
 > I was able to restore all the old data, and get the program running agai=
n,=20
 > but of course I would like to eliminate the reference to the old library=
 and=20
 > bring the code up to date.=20
 > Unfortunately, I've forgotten what little Access coding that I learned f=
or=20
 > that project, and I'm not sure how to proceed. I notice that there is a=
=20
 > help page that mentions unsupported commands with DAO 3.6 and suggests=
=20
 > replacements, but I don't think I'm using any of the older commands,=20
 > although I'm using commands of the same type.=20
 > I've tried to create a new Access 2000 database, import all the forms an=
d=20
 > recompile, but running the form gives me a "Compile Error Method or Data=
=20
 > Member not found" on 'gUpdateMonth =3D Updateset.UpdateMonth'=20
 > I would apreciate a bit of guidance here. Do I need to go learn the new=
=20
 > methods and manually rewrite the code?=20
 > Thanks=20
 > Jim Helfer=20
 > WTW Architects=20
=20
office_2();=20
 Sat, 14 Aug 2004 07:13:36 GMT Peter Russe
#3 / 7 MS DAO 2.5/3.5 compatibility Library Although there could be several=
 issues, the most likely one is that you are using 'dot'notation where 'ban=
g' notation is now required.=20
 That is, in Access2 you could reference fields by using things like formna=
me.fieldname but now you have to use formname!fieldname.=20
 I am guessing that the compiler is giving you the correct info and you nee=
d to plod through the code changing these references.=20
 Regards=20
 Peter Russell=20
 Quote:
 > Hi All,=20
 > Unfortunately, I've forgotten what little Access coding that I=20
 > learned for=20
 > that project, and I'm not sure how to proceed. I notice that there is a=
=20
 > help page that mentions unsupported commands with DAO 3.6 and suggests=
=20
 > replacements, but I don't think I'm using any of the older commands,=20
 > although I'm using commands of the same type.=20
 > I've tried to create a new Access 2000 database, import all the forms=20
 > and=20
 > recompile, but running the form gives me a "Compile Error Method or Data=
=20
 > Member not found" on 'gUpdateMonth =3D Updateset.UpdateMonth'=20
 > I would apreciate a bit of guidance here. Do I need to go learn the=20
 > new=20
 > methods and manually rewrite the code?=20
 > Thanks=20
 > Jim Helfer=20
 > WTW Architects=20
=20
=20
 Sat, 14 Aug 2004 15:04:00 GMT Jim Helfe
#4 / 7 MS DAO 2.5/3.5 compatibility Library=20
 Quote:> Any code module, Tools, References, remove the missing reference a=
nd check=20
 any=20
 > recommended DAO library should do it.=20
 > Though there are different versions of DAO libraries, just checking an=
=20
 > available one in the References list will usually do it. They are bug=20
 fixes=20
 > and not really code alterations, as far as I know.=20
 > DAO 3.51 appears to be the standard DAO library for A97. I've no idea wh=
at=20
 it=20
 > was for A95, and you'll be hard-pressed to find anyone with experience o=
f=20
 A95=20
 > here. By all accounts, it was a dog and most people morphed into A97.=20
 > It's not really clear what you have, "A95 and removing an administrative=
=20
 > install of O97". I suggest you remove everything, then decide exactly=20
 which=20
 > version of Office/Access you actually want to install. Few would argue=
=20
 against=20
 > A97 being better than A95.=20
 > Chris=20
=20
 What I meant to say is that I had Office 97 installed to the network=20
 folders, and we install users with a lot of "run from network server"=20
 options. Turns out that my code needs a reference to the "Microsoft DAO=20
 2.5/3.5 Compatibility Library" that's in F:\apps\MSApps\DAO\DAO2535.tlb=20
 Unfortunately, adding the reference to the "Microsoft DAO 3.6 Compatibilit=
y=20
 Library" didn't help much, so I assume that I'm going to have to update th=
e=20
 code to fix this for real.=20
 Strangely enough, if I try to unreference the tbl file and move it, and=20
 then reference it in a different place, the reference dialog box won't=20
 accept it. I can only reference it when it's in the original location. Not=
=20
 sure what that's about.=20
 Thanks for your help=20
 Jim Helfer=20
 WTW Architects=20
 Pittsburgh PA=20
 - Hide quoted text -- Show quoted text -

> > Hi All,=20
 > > I have a small database program originally written in Access 95. It=20
 ran=20
 > > with very little if any modification of the code, until I tried to=20
 remove=20
 > > the old administrative install (on the network drive) of Office 97.=20
 > > Right after that, the program crashes because of a missing reference.=
=20
 The=20
 > > missing reference is "MS DAO 25. 3.5 Compatibility Library." This is a=
=20
 file=20
 > > in the old Office 97 folder.=20
 > > I was able to restore all the old data, and get the program running=20
 again,=20
 > > but of course I would like to eliminate the reference to the old libra=
ry=20
 and=20
 > > bring the code up to date.=20
 > > Unfortunately, I've forgotten what little Access coding that I learned=
=20
 for=20
 > > that project, and I'm not sure how to proceed. I notice that there is =
a=20
 > > help page that mentions unsupported commands with DAO 3.6 and suggests=
=20
 > > replacements, but I don't think I'm using any of the older commands,=
=20
 > > although I'm using commands of the same type.=20
 > > I've tried to create a new Access 2000 database, import all the forms=
=20
 and=20
 > > recompile, but running the form gives me a "Compile Error Method or Da=
ta=20
 > > Member not found" on 'gUpdateMonth =3D Updateset.UpdateMonth'=20
 > > I would apreciate a bit of guidance here. Do I need to go learn the=20
 new=20
 > > methods and manually rewrite the code?=20
 > > Thanks=20
 > > Jim Helfer=20
 > > WTW Architects=20
=20
=20
 Sun, 15 Aug 2004 05:55:03 GMT office_link(); Jim Helfe
#5 / 7 MS DAO 2.5/3.5 compatibility Library=20
 Quote:> Although there could be several issues, the most likely one is tha=
t you=20
=20
are using 'dot'notation where 'bang' notation is now required.=20
 Quote:> That is, in Access2 you could reference fields by using things lik=
e=20
=20
formname.fieldname but now you have to use formname!fieldname.=20
 Quote:> I am guessing that the compiler is giving you the correct info and=
 you=20
=20
need to plod through the code changing these references.=20
 Quote:> Regards=20
 > Peter Russell=20
=20
 Yuck, I could hardly figure that bang and period stuff out in the first=20
 place.=20
 Oh well, I guess that's why they pay instead of this being a volunteer=20
 effort. Know any good Access books with a cogent explanation of this stuff=
?=20
 Thanks=20
 Jim Helfer=20
 WTW Architects=20
 Pittsburgh PA=20
 Quote:

 > > Hi All,=20
 > > Unfortunately, I've forgotten what little Access coding that I=20
 > > learned for=20
 > > that project, and I'm not sure how to proceed. I notice that there is =
a=20
 > > help page that mentions unsupported commands with DAO 3.6 and suggests=
=20
 > > replacements, but I don't think I'm using any of the older commands,=
=20
 > > although I'm using commands of the same type.=20
 > > I've tried to create a new Access 2000 database, import all the forms=
=20
 > > and=20
 > > recompile, but running the form gives me a "Compile Error Method or Da=
ta=20
 > > Member not found" on 'gUpdateMonth =3D Updateset.UpdateMonth'=20
 > > I would apreciate a bit of guidance here. Do I need to go learn the=20
 > > new=20
 > > methods and manually rewrite the code?=20
 > > Thanks=20
 > > Jim Helfer=20
 > > WTW Architects=20
=20
=20
 Sun, 15 Aug 2004 06:57:38 GMT david
#6 / 7 MS DAO 2.5/3.5 compatibility Library DAO2535.tlb is only a name/inde=
x file. You still have to have dao 3.5 installed.=20
 Also, it is registered as=20
 HKEY_CLASSES_ROOT\TypeLib\00025E04-0000-0000-C000-000000000046=20
 with a specific location.=20
 If you want to move it somewhere else, it has to be re-registered.=20
 converting (dot) to (bang) is not that difficult: just convert what Access=
=20
 objects to, and keep going until Access stops complaining.=20
 (david)=20
 Quote:
=20

 > > Any code module, Tools, References, remove the missing reference and c=
heck=20
 > any=20
 > > recommended DAO library should do it.=20
 > > Though there are different versions of DAO libraries, just checking an=
=20
 > > available one in the References list will usually do it. They are bug=
=20
 > fixes=20
 > > and not really code alterations, as far as I know.=20
 > > DAO 3.51 appears to be the standard DAO library for A97. I've no idea =
what=20
 > it=20
 > > was for A95, and you'll be hard-pressed to find anyone with experience=
 of=20
 > A95=20
 > > here. By all accounts, it was a dog and most people morphed into A97.=
=20
 > > It's not really clear what you have, "A95 and removing an administrati=
ve=20
 > > install of O97". I suggest you remove everything, then decide exactly=
=20
 > which=20
 > > version of Office/Access you actually want to install. Few would argue=
=20
 > against=20
 > > A97 being better than A95.=20
 > > Chris=20
 > What I meant to say is that I had Office 97 installed to the network=20
 > folders, and we install users with a lot of "run from network server"=20
 > options. Turns out that my code needs a reference to the "Microsoft DAO=
=20
 > 2.5/3.5 Compatibility Library" that's in F:\apps\MSApps\DAO\DAO2535.tlb=
=20
 > Unfortunately, adding the reference to the "Microsoft DAO 3.6 Compatibil=
ity=20
 > Library" didn't help much, so I assume that I'm going to have to update =
the=20
 > code to fix this for real.=20
 > Strangely enough, if I try to unreference the tbl file and move it, and=
=20
 > then reference it in a different place, the reference dialog box won't=
=20
 > accept it. I can only reference it when it's in the original location. N=
ot=20
 > sure what that's about.=20
 > Thanks for your help=20
 > Jim Helfer=20
 > WTW Architects=20
 > Pittsburgh PA=20
=20

 > > > Hi All,=20
 > > > I have a small database program originally written in Access 95. It=
=20
 > ran=20
 > > > with very little if any modification of the code, until I tried to=
=20
 > remove=20
 > > > the old administrative install (on the network drive) of Office 97.=
=20
 > > > Right after that, the program crashes because of a missing reference=
.=20
 > The=20
 > > > missing reference is "MS DAO 25. 3.5 Compatibility Library." This is=
 a=20
 > file=20
 > > > in the old Office 97 folder.=20
 > > > I was able to restore all the old data, and get the program running=
=20
 > again,=20
 > > > but of course I would like to eliminate the reference to the old lib=
rary=20
 > and=20
 > > > bring the code up to date.=20
 > > > Unfortunately, I've forgotten what little Access coding that I learn=
ed=20
 > for=20
 > > > that project, and I'm not sure how to proceed. I notice that there i=
s a=20
 > > > help page that mentions unsupported commands with DAO 3.6 and sugges=
ts=20
 > > > replacements, but I don't think I'm using any of the older commands,=
=20
 > > > although I'm using commands of the same type.=20
 > > > I've tried to create a new Access 2000 database, import all the form=
s=20
 > and=20
 > > > recompile, but running the form gives me a "Compile Error Method or =
Data=20
 > > > Member not found" on 'gUpdateMonth =3D Updateset.UpdateMonth'=20
 > > > I would apreciate a bit of guidance here. Do I need to go learn the=
=20
 > new=20
 > > > methods and manually rewrite the code?=20
 > > > Thanks=20
 > > > Jim Helfer=20
 > > > WTW Architects=20
=20
=20
 Sun, 15 Aug 2004 08:47:33 GMT Chris Mill
#7 / 7 MS DAO 2.5/3.5 compatibility Library I'm sorry Jim. I try not to mix=
 versions and I have never had at least these=20
 dreaded compatibility problems.=20
 If I find they have Officexx, I either supply them with a compatible versi=
on=20
 of Access or tell them to deinstall everything and start anew. It is clear=
=20
 that you/they have a mess of different versions.=20
 As far as I'm concerned, DAO compatibilty libraries can be determined from=
=20
 your development machine, where presumably it works, and distributed with=
=20
 runtime.=20
 Chris=20
=20
 Quote:

 > > Any code module, Tools, References, remove the missing reference and c=
heck=20
 > any=20
 > > recommended DAO library should do it.=20
 > > Though there are different versions of DAO libraries, just checking an=
=20
 > > available one in the References list will usually do it. They are bug=
=20
 > fixes=20
 > > and not really code alterations, as far as I know.=20
 > > DAO 3.51 appears to be the standard DAO library for A97. I've no idea =
what=20
 > it=20
 > > was for A95, and you'll be hard-pressed to find anyone with experience=
 of=20
 > A95=20
 > > here. By all accounts, it was a dog and most people morphed into A97.=
=20
 > > It's not really clear what you have, "A95 and removing an administrati=
ve=20
 > > install of O97". I suggest you remove everything, then decide exactly=
=20
 > which=20
 > > version of Office/Access you actually want to install. Few would argue=
=20
 > against=20
 > > A97 being better than A95.=20
 > > Chris=20
 > What I meant to say is that I had Office 97 installed to the network=20
 > folders, and we install users with a lot of "run from network server"=20
 > options. Turns out that my code needs a reference to the "Microsoft DAO=
=20
 > 2.5/3.5 Compatibility Library" that's in F:\apps\MSApps\DAO\DAO2535.tlb=
=20
 > Unfortunately, adding the reference to the "Microsoft DAO 3.6 Compatibil=
ity=20
 > Library" didn't help much, so I assume that I'm going to have to update =
the=20
 > code to fix this for real.=20
 > Strangely enough, if I try to unreference the tbl file and move it, and=
=20
 > then reference it in a different place, the reference dialog box won't=
=20
 > accept it. I can only reference it when it's in the original location. N=
ot=20
 > sure what that's about.=20
 > Thanks for your help=20
 > Jim Helfer=20
 > WTW Architects=20
 > Pittsburgh PA=20
=20

 > > > Hi All,=20
 > > > I have a small database program originally written in Access 95. It=
=20
 > ran=20
 > > > with very little if any modification of the code, until I tried to=
=20
 > remove=20
 > > > the old administrative install (on the network drive) of Office 97.=
=20
 > > > Right after that, the program crashes because of a missing reference=
.=20
 > The=20
 > > > missing reference is "MS DAO 25. 3.5 Compatibility Library." This is=
 a=20
 > file=20
 > > > in the old Office 97 folder.=20
 > > > I was able to restore all the old data, and get the program running=
=20
 > again,=20
 > > > but of course I would like to eliminate the reference to the old lib=
rary=20
 > and=20
 > > > bring the code up to date.=20
 > > > Unfortunately, I've forgotten what little Access coding that I learn=
ed=20
 > for=20
 > > > that project, and I'm not sure how to proceed. I notice that there i=
s a=20
 > > > help page that mentions unsupported commands with DAO 3.6 and sugges=
ts=20
 > > > replacements, but I don't think I'm using any of the older commands,=
=20
 > > > although I'm using commands of the same type.=20
 > > > I've tried to create a new Access 2000 database, import all the form=
s=20
 > and=20
 > > > recompile, but running the form gives me a "Compile Error Method or =
Data=20
 > > > Member not found" on 'gUpdateMonth =3D Updateset.UpdateMonth'=20
 > > > I would apreciate a bit of guidance here. Do I need to go learn the=
=20
 > new=20
 > > > methods and manually rewrite the code?=20
 > > > Thanks=20
 > > > Jim Helfer=20
 > > > WTW Architects=20
=20
=20
 Sun, 15 Aug 2004 08:46:45 GMT Page 1 of 1
 [ 7 post ] Relevant Pages 1. Access DAO 2.5/3.5 Compatibility Library
 eebf2c3492