<!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>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.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>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?</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Rgds</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=DWUTKA@marlow.com href="mailto:DWUTKA@marlow.com">Drew Wutka</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 5:25 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Scheduling an mdb
to run using AT</DIV>
<DIV><BR></DIV>What are you trying to run. Is it just a data routine, or
is it running<BR>reports? If it's just a data routine, I personally
recommend using the NT<BR>service OCX, which allows a VB .exe to run as an NT
service. Much easier to<BR>deal with, shows up in the list of services,
the ocx has an easy method to<BR>dump information in the event viewer,
etc.<BR><BR>Running reports can be done this way too, but it needs to use
Automation. <BR><BR>>From what I understand, VB.Net has the NT
Service capability built in.<BR><BR>Drew<BR><BR>-----Original
Message-----<BR>From: Software Design & Solutions Pty Ltd.<BR>To: <A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR>Sent:
5/8/03 10:08 PM<BR>Subject: [AccessD] Scheduling an mdb to run using
AT<BR><BR>Have any of you had much experience with scheduling applications to
run<BR>(ie. mdb files) using the AT command?<BR> <BR>I am trying to get a
job to run overnight for a client using the<BR>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>@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>Call Price.mdb<BR><BR>
_____ <BR><BR> <BR>I then get the message 'M:\Price\Price.mdb file
not found'.<BR> <BR>Because it is real PITN to keep mucking around with
this syntax in DOS,<BR>I am also having a play with some shareware(?) the
client had called<BR>WINAT. It seems good, but when I use it at my client site
to edit the<BR>paremeters of the AT command, extra characters appear at the
end of the<BR>command, so I am not sure whether the command will work or
not.<BR>Characters are things like pipes and @symbols. <BR> <BR>So my
question for anyone using AT is: do you have any tips to share?<BR>What is the
most reliable way you have found to schedule an mdb to
run?<BR> <BR>TIA<BR>Kath<BR> <BR> <BR>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>
<<A
href="mailto:SDSSoftware@Optusnet.com.au">mailto:SDSSoftware@Optusnet.com.au</A>>
<BR> <<ATT11462.txt>>
<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>