Mark A Matte
markamatte at hotmail.com
Tue Apr 3 14:23:36 CDT 2007
My issue reared its ugly head in an A97 db that was created, and currently running, in A97. The thing that concerned me was that I thought that if the libraries were not 'checked' under references...they were not used. But in this case DAO 3.6 was checked and DAO 3.51 was not in the list. Once I added the 3.51 dll to the machine and registered it(3.51 still NOT checked in references) the db ran fine...so this means that A97 still needed the other dll's even though they weren't checked. With this being the case...what is the point of selecting the references if it is just going to use what it wants anyway? I'm confused again? Mark A. Matte >From: "William Hindman" <wdhindman at dejpolsystems.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 15:11:41 -0400 > >...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 > > > > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ Can’t afford to quit your job? – Earn your AS, BS, or MS degree online in 1 year. http://www.classesusa.com/clickcount.cfm?id=866145&goto=http%3A%2F%2Fwww.classesusa.com%2Ffeaturedschools%2Fonlinedegreesmp%2Fform-dyn1.html%3Fsplovr%3D866143