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 >