<!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 Stuart - I will try adding
that ref to msaccess.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Cheers</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=stuart@lexacorp.com.pg href="mailto:stuart@lexacorp.com.pg">Stuart
McLachlan</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=SDSSoftware@optusnet.com.au
href="mailto:SDSSoftware@optusnet.com.au">Software Design & Solutions Pty
Ltd.</A> ; <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 2:24 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Scheduling an mdb
to run using AT</DIV>
<DIV><BR></DIV>On 9 May 2003 at 13:08, Software Design & Solutions P
wrote:<BR><BR>> Have any of you had much experience with scheduling
applications to run (ie. mdb files) using the AT command?<BR>> <BR>> I
am trying to get a job to run overnight for a client using the following
syntax:<BR>> <BR>> at 14:26 /interactive /Every:M,T,W,Th,F cmd /c
D:\Prices\Priceload.bat<BR>> <BR>> where the files Priceload.bat
contains the following:<BR>> <BR>>
--------------------------------------------------------------------------------<BR>>
<BR>> @ECHO OFF<BR>> REM Daily Price File Load<BR>> TITLE GBST PRICE
LOAD<BR>> <BR>> M:<BR>> cd \Price<BR>> echo ENTER PRICE
FOLDER<BR>> ntsleep 2 > nul<BR><BR>What OS? (I don't recognise NTSLEEP -
what is it doing)<BR><BR>> <BR>> Call Price.mdb<BR>> <BR>>
--------------------------------------------------------------------------------<BR>>
<BR>> <BR>> I then get the message 'M:\Price\Price.mdb file not
found'.<BR>> <BR><BR>It is actually looking for a file called
M:\Price\Price.mdb.bat :-(<BR>CALL will only run another batch
file.<BR><BR>To open the MDB , you need to actually run Access and give the
MDB name as a parameter<BR><BR>Replace the line - Call Price.mdb<BR> with
-<BR>"c:\program files\microsoft office\office\msaccess.exe"
Price.mdb<BR><BR>or whatever the path is to the access application<BR><BR>>
<BR>> 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?<BR>> <BR><BR>I generally just do a<BR><BR>AT 05:00
/Every:Mo,Tu,We,Th,Fr GetPrice<BR><BR>Then I create a batchfile
(GetPrice.cmd) which just contains one line:<BR><BR>"c:\program
files\microsoft office\office\msaccess.exe"
C:\Apps\GetPrice.mdb<BR><BR><BR><BR><BR>-- <BR>Stuart McLachlan<BR>Lexacorp
Ltd<BR>Application Development, IT Consultancy<BR><A
href="http://www.lexacorp.com.pg">http://www.lexacorp.com.pg</A><BR><BR>_______________________________________________<BR>AccessD
mailing list<BR><A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></BLOCKQUOTE></BODY></HTML>