[AccessD] Excel automation issue

John,

I had a similar error recently...but not exactly the same...only some 
machine had the error...but all machines 'appeared' to be the same.  My 
problem was around DAO connections...in the VBA window, under 
tools...references...everyone had the same 3 things checked including DAO 
3.6

What I later found to be the problem was not what is checked...but what is 
available to be checked.  Apparently Access needs some of the old DLLs even 
though they are not checked in References.  My culprit was DAO 3.51. The 
machines that were having the problem with what seemed to be sound 
code...were indeed missing the 3.51 dll even though the db supposedly was 
not being used.  I copied the file to each machine, registered them...and 
everything worked fine.

Your error and mine weren't the same, but from what I can remember very 
similar...and both were good code and referenced automation.

at the time I found something on MS site describing the old dll missing 
issue...but I can't find it now.

Good Luck,

Mark A. Matte


>From: "John Skolits" <askolits at ot.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 issue
>Date: Tue, 3 Apr 2007 10:34:14 -0400
>
>I just realized the SR-1 is not for XP. Only up till 2000
>I guess I assumed that a later version of 2.8 would be for XP as well.
>
>Either way, I still have the automation issue which for the life of me . I
>can't figure out.
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
>Sent: Tuesday, April 03, 2007 10:11 AM
>To: 'Access Developers discussion and problem solving'
>Subject: Re: [AccessD] Excel automation issue
>
>Hi John,
>
>I can only answer the MDAC 2.8 issue.  You need to find the 'MDAC 2.8' page
>on MS's site.  There are several versions of MDAC 2.8, each for a different
>Windows OS.
>
>Dan
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits
>Sent: Tuesday, April 03, 2007 8:36 AM
>To: 'Access Developers discussion and problem solving'
>Subject: [AccessD] Excel automation issue
>
>I have a problem on my PC but it's not occurring on any other PC.
>
>When trying to do a CopyFromRecordset to Excel. I receive the following
>error.
>
>"Class does not support automation or does not support expected interface"
>
>The only new thing I have done lately was to install SqlServer 2005 and VB
>2005. These were not installed previous to this issue and are not install 
>on
>any of my other PCs.
>
>Ms Knowledgebase seems to point to using Access97 with Excel. But I'm
>running Access 2000. I have all the latest Service packs.
>
>I have totally removed Office and reinstalled.
>
>The other odd thing was I found an MDAC that's 2.8 SR1. Thinking it may fix
>the problem, I tried to run it and it said "This setup does not support
>installing on this operating system"
>
>Anyone run into this yet.
>
>John Skolits
>
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Get a FREE Web site, company branded e-mail and more from Microsoft Office 
Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/