[AccessD] Excel automation issue

William Hindman wdhindman at dejpolsystems.com
Tue Apr 3 14:11:41 CDT 2007


...two things I watch for here ...when code requires DAO 3.51 to compile it 
means I've got legacy code from an older version of Access running ...and 
when I start getting automation errors on one system and not on others, it 
usually points to the DAO/ADO references being out of sequence on that 
system ...which can happen when you do third party installs ...one reason I 
got religion about coding explicitly to DAO or ADO and not forcing Access to 
guess.
William Hindman

----- Original Message ----- 
From: "Mark A Matte" <markamatte at hotmail.com>
To: <accessd at databaseadvisors.com>
Sent: Tuesday, April 03, 2007 10:49 AM
Subject: Re: [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/
>
> -- 
> 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