<!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 6.00.2722.900" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=495373116-13052003><FONT face=Arial color=#0000ff size=2>Hey,
if it works, it works. The big advantage in this case, with a VB service
versus AT, is that you are using Access vs. VB. Access is much heavier on
the resources then VB is, so a VB service that runs a data crunching routine
would be more lite weight then a full blown .mdb.</FONT></SPAN></DIV>
<DIV><SPAN class=495373116-13052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=495373116-13052003><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>
Monday, May 12, 2003 9:14 PM<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>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></BLOCKQUOTE></BODY></HTML>