[AccessD] Scheduling an mdb to run using AT

Hi drew - this is an mdb - the basic process it performs is to log on to an external system, read in some data, manipulate that data and export it out to an external txt file.

I have done it in vba only because I do not know pure vb (and don't own it). There's no requirement to change it as it does the job - just need it automated. They are running Windows NT. You lost me on the NT service OCX. What is that?

Rgds
Kath
  ----- Original Message ----- 
  From: Drew Wutka 
  To: 'AccessD at databaseadvisors.com ' 
  Sent: Friday, May 09, 2003 5:25 PM
  Subject: RE: [AccessD] Scheduling an mdb to run using AT


  What are you trying to run.  Is it just a data routine, or is it running
  reports?  If it's just a data routine, I personally recommend using the NT
  service OCX, which allows a VB .exe to run as an NT service.  Much easier to
  deal with, shows up in the list of services, the ocx has an easy method to
  dump information in the event viewer, etc.

  Running reports can be done this way too, but it needs to use Automation.  

  >From what I understand, VB.Net has the NT Service capability built in.

  Drew

  -----Original Message-----
  From: Software Design & Solutions Pty Ltd.
  To: AccessD at databaseadvisors.com
  Sent: 5/8/03 10:08 PM
  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 <mailto:SDSSoftware at Optusnet.com.au> 
   <<ATT11462.txt>> 
  _______________________________________________
  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/20030509/b269982b/attachment-0001.html>