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