[AccessD] ADO code stopped working

...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
>