<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2>Thanks for the tip on WinAT Jim. Both
yours and Stuart's examples call msaccess.exe directly so that's what I will add
and test. Thanks</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=jimdettman@earthlink.net href="mailto:jimdettman@earthlink.net">Jim
Dettman</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, May 09, 2003 10:42 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Scheduling an mdb
to run using AT</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=190043612-09052003><FONT face=Arial color=#0000ff
size=2>Kath,</FONT></SPAN></DIV>
<DIV><SPAN class=190043612-09052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=190043612-09052003><FONT face=Arial color=#0000ff
size=2> WINAT is not shareware, but comes with the Windows NT resource
kit. I use it at one clients site and have never had a problem with
it. I simply call a batch file that executes Access and the MDB.
Has worked fine for years. An example of the batch file I use is
below.</FONT></SPAN></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Jim Dettman<BR>President,<BR>Online Computer Services of
WNY, Inc.<BR>(315) 699-3443<BR><A
href="mailto:jimdettman@earthlink.net">jimdettman@earthlink.net</A>
</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>REM Calls extract program for a
full regen and process<BR>REM (Extract, Generate, and Send)<BR>REM Date is not
passed. Relies on server date to calulate Monday date.<BR>"C:\Program
Files\Microsoft Office\Office\MSACCESS.EXE" "C:\ESCS2\ESCXTR.MDB" /CMD * * *
<BR></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Software
Design & Solutions Pty Ltd.<BR><B>Sent:</B> Thursday, May 08, 2003 11:08
PM<BR><B>To:</B> AccessD@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
Scheduling an mdb to run using AT<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Have any of you had much
experience with scheduling applications to run (ie. mdb files) using the AT
command?</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>I am trying to get a job to run
overnight for a client using the following syntax:</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=918301102-09052003><FONT face=Arial color=#0000ff size=2>at 14:26
/interactive /Every:M,T,W,Th,F cmd /c
</FONT></SPAN>D:\Prices\Priceload.bat</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>where the files Priceload.bat
contains the following:</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>
<HR>
</FONT></DIV>
<DIV><FONT face=Arial color=#ff0000 size=2>@ECHO OFF<BR>REM Daily Price File
Load<BR>TITLE GBST PRICE LOAD</FONT></DIV>
<DIV><FONT color=#ff0000></FONT> </DIV>
<DIV><FONT face=Arial color=#ff0000 size=2>M:<BR>cd \Price<BR>echo ENTER
PRICE FOLDER<BR>ntsleep 2 > nul</FONT></DIV>
<DIV><FONT color=#ff0000></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><FONT color=#ff0000>Call
Price.mdb<BR></FONT>
<HR>
</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>I then get the message
'M:\Price\Price.mdb file not found'.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Because it is real PITN to keep
mucking around with this syntax in DOS, I am also having a play with some
shareware(?) the client had called WINAT. It seems good, but when I use it
at my client site to edit the paremeters of the AT command, extra characters
appear at the end of the command, so I am not sure whether the command will
work or not. Characters are things like pipes and @symbols. </FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>So my question for anyone using
AT is: do you have any tips to share? What is the most reliable way you have
found to schedule an mdb to run?</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>TIA</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath Pelletti<BR>Software Design
& Solutions Pty Ltd.<BR>Ph: 9505-6714<BR>Fax: 9505-6430<BR><A
href="mailto:SDSSoftware@Optusnet.com.au">SDSSoftware@Optusnet.com.au</A></FONT></DIV></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>