<!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>Drew - thanks for that explanation.
So if this code were in vb instead of vba then I could look at building an NT
service OCX and add my system as a service.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>OK - but for an mdb I may as well us
AT?</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<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> Saturday, May 10, 2003 7:23
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Scheduling an mdb
to run using AT</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff size=2>Pure
VB codes almost exactly the same as VBA. The syntax is identical, there
are just a few minor changes in functions (such as AddressOf is a default
ability in VB, and Eval is only available in VBA).</FONT></SPAN></DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff size=2>As
far as the NT Service OCX, let me explain....</FONT></SPAN></DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff size=2>A
service is something that runs on your machine whether you are logged onto it
or not. (Once Windows has loaded it's device driver's, etc., then it
starts the services). In 9x, services are just a registry entry
(HKLM\Software\Microsoft\Windows\CurrentVersion\RunService) (That may be
RunAsService...don't remember, and it's not on NT machines, which is what I am
using now...) Any program can be placed there in the registry, and it is
run by windows as soon as it comes up....regardless of whether a desktop is
loaded or not.</FONT></SPAN></DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff size=2>Now,
an NT service is similar, however, it's not a normal registry entry.
Services is part of the Administrative control panel. (Control Panel
--> Administrative Tools). That lists every service running on your
machine. From that panel, you can start and stop services, you can set
whether they can interact with the desktop, or what NT account is used to run
the service as. Pretty flexible. However, to 'build' an NT
service, requires callback capability, since the system has to 'holler' at the
service to start or stop, etc. The NT service OCX (ActiveX control)
provides that callback capability to VB.</FONT></SPAN></DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=637384216-09052003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Software Design &
Solutions Pty Ltd. [mailto:SDSSoftware@Optusnet.com.au]<BR><B>Sent:</B>
Friday, May 09, 2003 3:46 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD] Scheduling an
mdb to run using AT<BR><BR></FONT></DIV>
<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></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>