[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