[AccessD] Scheduling an mdb to run using AT

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

Kath
  ----- Original Message ----- 
  From: Jim Dettman 
  To: accessd at databaseadvisors.com 
  Sent: Friday, May 09, 2003 10:42 PM
  Subject: RE: [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


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


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030513/1cea3e65/attachment-0001.html>