[AccessD] Excel automation issue - SOLVED!

John Skolits askolits at ot.com
Tue Apr 3 10:13:29 CDT 2007


Bingo.
I copied over an older DAO 2.5/3.51 from one of my PCs.
Added it to my References and removed DAO 3.60 from the reference.
Compiled, and it worked.
Closed Access.
Opened it, removed Dao 2.5/3.51 reference and added back Dao 3.60.
And everything is now fine.

Weird.

Thanks for all your help!

John




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
Sent: Tuesday, April 03, 2007 10:56 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Excel automation issue

WAG. Is it possible the DAO reference was changed to an older version when
you installed VB or the ADO reference replaced the DAO? Just a thought.
Jim Hale

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits
Sent: Tuesday, April 03, 2007 9:34 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Excel automation issue


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

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list