[AccessD] Docmd.SendObject

What about ALWAYS ensuring that there is a file present.  If the routine
deletes it, recreate it at the end of the routine.
Would that do it?
Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Thursday, May 01, 2008 1:40 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Docmd.SendObject


Thanks Max,

But ...No.  I think It has something to do with the checking for the FTP and
not finding one(or some code in between).  If it does not find a file...it
never gets to the email part...so I'm not sure where it would impact.  

Currently If I run just the email part...runs fine...over and over
again...but if I let it step through the FTP and other stuff...it will run
if it finds a file...if no file...I can not even run just the email part.
It steps through as if everything is OK...just no email.  There is error
handling, but NO error?

Thanks,

Mark A. Matte





> From: max.wanadoo at gmail.com
> To: accessd at databaseadvisors.com
> Date: Thu, 1 May 2008 07:26:15 +0100
> Subject: Re: [AccessD] Docmd.SendObject
>
> Is the PC set to Hibernate perhaps?
> Just guessing really.
> Max
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A 
> Matte
> Sent: Thursday, May 01, 2008 2:06 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Docmd.SendObject
>
>
> Hello All,
>
> I have an MDB that does some FTP,Unzip,Import, and email.
>
> Its been running a few years...but recently put it on a newer 
> machine...running 2000 Server...A2K.
>
> All of the functionality still works...at first...
>
> It is using a form timer to check for a file...and when it finds 
> 1...it does all the other stuff.
>
> Problem is after an hour or so...it stops sending email. It does not 
> error...if I go and step through the whole thing...or just the email 
> part...it just steps right over the docmd.sendobject without erroring. 
> If I reopen the mdb...it runs fine for a bit...b ut same issue comes up?
>
>
> Any ideas?
>
> Thanks,
>
> Mark A. Matte
> _________________________________________________________________
> In a rush? Get real-time answers with Windows Live Messenger.
> http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_R
> efresh
> _realtime_042008
> --
> 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

_________________________________________________________________
Back to work after baby-how do you know when you're ready?
http://lifestyle.msn.com/familyandparenting/articleNW.aspx?cp-documentid=579
7498&ocid=T067MSN40A0701A
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com