Re: class events stop firing with ADO 2.8

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: keepITcool (xrrcvgpbby_at_puryyb.ay)
Date: 11/14/04 

Date: Sat, 13 Nov 2004 16:20:27 -0800

so.. you do have a referencing problem...

also your use of ADO and ADOX is confusing.
ADO would be Microsoft ActiveX Data Objects 2.8 Library
ADOX would be MS ADO Ext.2.8 for DLL and Security

First you'd need to save the addin when the references
both to ADO and ADOX are in sync, and to the "lowest" possible version.

Perhaps it's an idea to rewrite all adox calls/object
to LATEBOUND, and remove all adox references.
(although this would mean a performance loss when objects are created,

I assume you wouldnt have that many adox calls,most of what you can do
with ADOX you can do with ADO's openschema and generally faster too.

Changing code to "late-binding":

Change all 'typed' adox object declarations to OBJECT

Change lines like
set adoxCAT = new adox.catalog
to
set adoxCAT = createobject("adox.catalog")

Change
all adox constants
to
their numeric values.

HTH 

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam
ThankYou_jeff wrote :
> 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

  • Lost vba references and adox conflict
    ... I've been developing an Excel add-in and in my most recent version, ... references disappeared. ... I am using ADO and ADOX and want the add-in to work on Excel 2000 or later ...
    (microsoft.public.excel.programming)
  • RE: Command Object Nightmares
    ... This component is somewhat hard to find in the project references due ... You will find that it's extremely easy to code with ADOX and ADODB, ... Happy coding! ... "Gwyn Evans" wrote: ...
    (microsoft.public.data.ado)
  • Re: ADOX i Access VB. Library?
    ... scroll through the list of available references until you find Microsoft ADO ... It's not necessary that the version of ADOX ... > Dim cat As ADOX.Catalog ...
    (microsoft.public.access.modulesdaovba)
  • Re: Member or Data Member not Found
    ... you've removed the reference to ADO. ... your declaration for tdf is incorrect. ... 2002 only references ADO, but you can add a reference to DAO. ... You must disambiguate as Dim rst As DAO.Recordset. ...
    (microsoft.public.access.formscoding)
  • Re: Adding to Table from Drop Down Box
    ... As for ADO, I am so glad you showed me another way! ... select Tools | References from the menu bar. ... Dim strSQL As String ... It then has me create an INSERT INTO SQL statement ...
    (microsoft.public.access.formscoding)