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