Running a MDB as a service

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Hello,
Does anyone know if there is a way (and how to do it) to run a MDB as a
service. I've got a form that automatically runs when the mdb is run which
has a timer. It does certain processing at a specific time each day. I
wanted to run it as a service (if I could) so that it would keep running
even when other users have logged off.
Thanks
Cheers :)
 
Why not just set up a task to run once a day, )or at your specific time. You
can have the task launch the mdb file. Just make sure your code after
running simply does a

application.Quit

You can either write a VBS script, or even just use the start command


start "c:\dailymdbrun\your.mdb"
 
Thanks for the info, but I'm not talking about running it as a webservice.
I'm talking about running it as a Windows 2000 service. I've got the form to
auto-open (run) when the mdb file is executed. The form has a timer which
handles firing the processing that needs to take place.
 
That's a good idea...didn't think about that. Would the task run if the
system was at the login dialog...if now one has logged it yet? There may be
a user to go into the system and log off. At the predetermed time, would the
task fire if a user had logged off and now one else had logged in yet?
 
Yes, it would run. Any windows version 2000 or later has a nice schedule
manager.

In fact, even win9x has scheduling, and you can set the time it runs.

Most versions of windows you can find the scheduler in the control panel. It
has previsions for what user the task will run under and even the password
stuff. All of this stuff will work even if the user is logged off...
 
Thanks, I'll give that a try. I think that will solve my problem.
Thanks again!
Good Day...
 
Randy said:
Does anyone know if there is a way (and how to do it) to run a MDB as a
service. I've got a form that automatically runs when the mdb is run which
has a timer. It does certain processing at a specific time each day. I
wanted to run it as a service (if I could) so that it would keep running
even when other users have logged off.
Click to expand...

Alternatively, if you own VB, you could transfer all this code to VB,
make it a service and run it as a stand alone program. Without
requiring any forms at all.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top