[AccessD] Excel Automation problem

This is the error very similar to when you have DAO36 selected but DAO3.51 
is not on the machine at all.  I have found that downloading 
DAO350.dll...registering it...and everything is fixed.

Learned this after chasing down the error on 1 of 2 identical(so I thought) 
machines.  The offending machine did not have 3.51 on it...I didn't have it 
checked in references...so I never looked to see if it was there.  After 
putting it on the machine/registering...the error went away.

There is a reference to it on MS site...but no explanation as to why it 
causes these errors, sometimes.

Good Luck,

Mark A. Matte




>From: "Michael R Mattys" <mmattys at rochester.rr.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Excel Automation problem
>Date: Fri, 20 Apr 2007 12:47:34 -0400
>
>The problem may be that Access keeps putting your
>references out of order. You'd need to make sure that
>DAO36 is ahead of ADO##
>
>Michael R. Mattys
>MapPoint & Access Dev
>www.mattysconsulting.com
>
>----- Original Message -----
>From: "Cindy Fraase" <CFraase at officeimagesinc.com>
>To: "Access Developers discussion and problem solving"
><accessd at databaseadvisors.com>
>Sent: Friday, April 20, 2007 12:40 PM
>Subject: [AccessD] Excel Automation problem
>
>
> > Hi all,
> > I'm really mystified as to what is happening. The following line of code
> > works fine on my machine, but fails with this error on another. Both
> > machines are running Access 2003 and all of the references match. The
> > database is in Access 2002-3 format. It's located on the server, so I'm
> > running exactly the same database as he is.
> >
> > I've created an Excel sheet via automation and am filling it with data
> > here.
> >
> > The line is:
> >
> > objSheet2.Range("A2").CopyFromRecordset rsSalary
> >
> > The error message I get is:
> > 430 Class does not support Automation or does not support expected
> > interface.
> >
> > Any insights would be greatly appreciated!
> >
> > Thanks,
> > Cindy
> >
> >
> >
> > Cynthia Fraase
> > Asst. Controller
> > Direct: 678-325-3251
> > Cell:     770-318-0628
> > Fax:     770-641-2656
> >
> > www.officeimagesinc.com
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Don’t quit your job – Take Classes Online and Earn your Degree in 1 year. 
Start Today! 
http://www.classesusa.com/clickcount.cfm?id=866146&goto=http%3A%2F%2Fwww.classesusa.com%2Ffeaturedschools%2Fonlinedegreesmp%2Fform-dyn1.html%3Fsplovr%3D866144