John Skolits
askolits at ot.com
Tue Apr 3 08:36:06 CDT 2007
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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: Wednesday, November 29, 2006 4:53 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Email Automation to Outlook problem It may be a windows event conflict. I am not sure if the timer is an Access thing or Access running a windows api. I do know that if Outlook happens to be sending or receiving when I try and send an email from Access an error is generated. This may be way out in left field but something to consider. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Wednesday, November 29, 2006 1:23 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Email Automation to Outlook problem I'll have to give this a try...but if it had any updates...they would have to have been automatic...its an old box running 2K Server...and I haven't run any updates in quite sometime. The weird part for me...is I can run the code from a button...but not a timer event??? Thanks, 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] Email Automation to Outlook problem >Date: Wed, 29 Nov 2006 16:12:25 -0500 > >...have you tried a restore point before it started failing ...imnsho >Microsoft has returned to issuing updates without thoroughly vetting >them ...it seems everytime MS does an update these days, my phone >starts ringing :( > >William Hindman >----- Original Message ----- >From: "Mark A Matte" <markamatte at hotmail.com> >To: <accessd at databaseadvisors.com> >Sent: Wednesday, November 29, 2006 3:24 PM >Subject: Re: [AccessD] Email Automation to Outlook problem > > > >I am actually having a related issue right now. I have a db that > >imports data every 30 minutes...does an analysis...and emails > >results using outlook. > > It worked fine for a year...and now outlook crashes almost > >everytime >with > > "An unknown Error". If I execute the exact same code from a button > > instead of a timer, it runs fine...I'm lost at this time. I need a > > way to send >an > > email without using outlook...I guess? > > > > Thanks, > > > > Mark A. Matte > > > >>From: "Gustav Brock" <Gustav at cactus.dk> > >>Reply-To: Access Developers discussion and problem > >>solving<accessd at databaseadvisors.com> > >>To: <accessd at databaseadvisors.com> > >>Subject: Re: [AccessD] Email Automation to Outlook problem > >>Date: Wed, 29 Nov 2006 18:09:03 +0100 > >> > >>Hi Susan and Chris > >> > >>Oh, that's another story - I don't use Outlook - so I cannot help. > >>Could it be an automatic Windows Updating issue? > >> > >>/gustav > >> > >> >>> ssharkins at setel.com 29-11-2006 17:40:32 >>> > >>Gustav, > >> > >> This is something that Outlook seems to do on its own -- at least > >>on my system. An address that's worked for years will suddenly not > >>send. In the header, I can see the apostrophes. I delete the > >>address, re-enter it, >and > >>9 > >>times out of 10, it goes. No clue... > >> > >> In my case, there's no code involved -- this is all Outlook. > >> > >>Susan H. > >> > >>The obvious solution is to adjust your code to stop wrapping the > >>address in apostrophes. > >>If, for some reason, that can't be done, change these to brackets like: > >> > >> <johndoe at aol.com> > >> > >>-- > >>AccessD mailing list > >>AccessD at databaseadvisors.com > >>http://databaseadvisors.com/mailman/listinfo/accessd > >>Website: http://www.databaseadvisors.com > > > > _________________________________________________________________ > > Talk now to your Hotmail contacts with Windows Live Messenger. > > >http://clk.atdmt.com/MSN/go/msnnkwme0020000001msn/direct/01/?href=http: >//get.live.com/messenger/overview > > > > -- > > 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 _________________________________________________________________ View Athletes Collections with Live Search http://sportmaps.live.com/index.html?source=hmemailtaglinenov06&FORM=MGAC01 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com