MartyConnelly
martyconnelly at shaw.ca
Sun Feb 4 22:01:26 CST 2007
Well assuming you have installed MDAC 2.8 The Access reference Microsoft ActiveX Data Object 2.8 Library should point at C:\Program Files\Common Files\System\ado\msado15.dll Depending on the upgrade path you may find the default ADO Access reference pointing at C:\Program Files\Common Files\System\ado\msado21.tlb which is quite antique, circa 1999, so switch it The older tlb versions give MDAC backward compatibility William Hindman wrote: >...another gem for the archive. > >William Hindman > >----- Original Message ----- >From: "MartyConnelly" <martyconnelly at shaw.ca> >To: "Access Developers discussion and problem solving" ><accessd at databaseadvisors.com> >Sent: Sunday, February 04, 2007 8:36 PM >Subject: Re: [AccessD] ADO code stopped working > > > > >>If you look at the references you will see >> >>Microsoft ActiveX Data Object 2.0 Library >>Microsoft ActiveX Data Object 2.1 Library >>Microsoft ActiveX Data Object 2.5 Library >>Microsoft ActiveX Data Object 2.8 Library >> >>However, they refer to the following files (respectively): see path name >> >>msado20.tlb >>msado21.tlb >>msado25.tlb >>msado15.tlb >> >>Point at which ever is msado15.tlb >>that is default current one active >> >> >>This applies through all the mdacs >>http://support.microsoft.com/kb/q201576/ >> >>Jennifer Gross wrote: >> >> >> >>>Hi Everyone, >>> >>>W2K SP4 / A2K SP3 / terminal server >>> >>>I have a database that has some DAO and some ADO code. Recently all ADO >>>stopped working. DAO is still working fine. Anytime code utilizing ADO >>>runs it shuts down the database abruptly, leaving the LDB file. We were >>>also having problems with the Windows Management databases locking up >>>and a reinstall of the latest MDAC took care of that problem, but did >>>not solve the ADO problem. ADO was working fine for end of year >>>reporting. There are no missing references. After the MDAC reinstall I >>>unchecked references, closed down, opened up and rechecked references. >>> >>>Any help would be greatly appreciated. >>> >>>Thank you, >>> >>>Jennifer Gross >>>databasics >>>2839 Shirley Drive >>>Newbury Park, CA 91320-3068 >>>office: (805) 480-1921 >>>fax: (805) 499-0467 >>> >>> >>> >>> >>> >>> >>-- >>Marty Connelly >>Victoria, B.C. >>Canada >> >>-- >>AccessD mailing list >>AccessD at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/accessd >>Website: http://www.databaseadvisors.com >> >> >> > > > > > -- Marty Connelly Victoria, B.C. Canada