[AccessD] Scheduling an mdb to run using AT

Kath,

  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.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

REM Calls extract program for a full regen and process
REM (Extract, Generate, and Send)
REM Date is not passed.  Relies on server date to calulate Monday date.
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\ESCS2\ESCXTR.MDB" /CMD * * *

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Software Design &
Solutions Pty Ltd.
  Sent: Thursday, May 08, 2003 11:08 PM
  To: AccessD at databaseadvisors.com
  Subject: [AccessD] Scheduling an mdb to run using AT


  Have any of you had much experience with scheduling applications to run
(ie. mdb files) using the AT command?

  I am trying to get a job to run overnight for a client using the following
syntax:

  at 14:26 /interactive /Every:M,T,W,Th,F cmd /c D:\Prices\Priceload.bat

  where the files Priceload.bat contains the following:

----------------------------------------------------------------------------
--

  @ECHO OFF
  REM Daily Price File Load
  TITLE GBST PRICE LOAD

  M:
  cd \Price
  echo ENTER PRICE FOLDER
  ntsleep 2 > nul

  Call Price.mdb

----------------------------------------------------------------------------
--


  I then get the message 'M:\Price\Price.mdb file not found'.

  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.

  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?

  TIA
  Kath


  Kath Pelletti
  Software Design & Solutions Pty Ltd.
  Ph: 9505-6714
  Fax: 9505-6430
  SDSSoftware at Optusnet.com.au
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030509/a18ff811/attachment-0001.html>