Re: class events stop firing with ADO 2.8

From: ThankYou_jeff (ThankYoujeff_at_discussions.microsoft.com)
Date: 11/14/04


Date: Sat, 13 Nov 2004 16:00:01 -0800

Thanks but there are no missing references; other than perhaps the "MS ADO
Ext.2.7 for DLL and Security" which is automatically updated to "MS ADO
Ext.2.8 for DLL and Security" when the Add-in is manually opened in the VB
IDE [Alt-F11]. Once that reference is replaced the Add-in works for ADO 2.8.
Then, of course, the Add-in will not work at all for ADO 2.7 {since "MS ADO
Ext.2.8 for DLL and Security" is truely missing. VB IDE won't automatically
downgrade to 2.7}.

"keepITcool" wrote:

> Check your references in VBE.
>
> if ANY reference is listed as ISMISSING this may well cause the hiccup.
>
>
>
>
>
> --
> keepITcool
> | www.XLsupport.com | keepITcool chello nl | amsterdam
>
>
> ThankYou_jeff wrote :
>
> > Excel add-in has been working for 2 years using ado 2.7; it fails on
> > ado 2.8. Here's stripped down version that displays message boxes



Relevant Pages

  • RE: references trouble (maybe...?)
    ... the 'name' of the ADO .dll is ADODB and not ADO as I mentioned ... reference it from there (delete the existing reference then click on Browse ... Then, when running the installation wizard I include the .dll file, to be ...
    (microsoft.public.access.modulesdaovba)
  • XP & Vista ADOX Library
    ... XP require "ADO Ext. 2.8 for DLL and Security". ... 'Load a reference to the ADO Ext. 2.8 for DLL and Security ...
    (microsoft.public.access.formscoding)
  • Re: XP & Vista ADOX Library
    ... ADOX version must be "ADO Ext. 6.0 for DLL and Security". ... 'Load a reference to the ADO Ext. 2.8 for DLL and Security ... Dim ref As Reference ...
    (microsoft.public.access.formscoding)
  • Re: How to create a database from nothing?
    ... set a reference to COM adox ext 2.x for dll and security ...
    (microsoft.public.dotnet.general)
  • Re: How to create a database from nothing?
    ... set a reference to COM adox ext 2.x for dll and security ...
    (microsoft.public.dotnet.languages.csharp)