Schedule Access Database

[withoutaclue]

Im using Win NT and dont have access to Task Sceduler on Run command.

How can i schedule a Access database to open Weekdays at 11.30 pm, on my local machine and not on the server.

I been reading past notes and nothing so far as helped,,

Any sugestions any one???

 

[beetee]

Make a second Access database, VBA program, C++ program, whatever, that runs all the time and launches your other application. Who knows, in time, you may wind up with your own scheduling application.

 

[JimInKS]

withoutaclue,

Windows NT does have a task scheduler.
But, I am a little confused by your statement about your local machine vs the server.

If your machine is running NT, then the simplest thing to do is to install Internet Explorer 5 or higher. This will also install Task Scheduler. Open "My Computer" and you should see a folder called "Scheduled Tasks".

Older versions of NT have the AT scheduler which is a command line only scheduler. It is harder to use, but would still work. For some info on AT, open a command (DOS) window and type AT /?.

 

[beetee]

I run Windows NT here at work as well, but the system adminstrators have deemed that I do not require access to the scheduler. I suspect that is what has happened to WAC as well.

 

[withoutaclue]

Beetee u r coorect, work has deemed it so we cant use task scheduler,

I know that At commands do work, and in have tried looking at the dos help, but still no luck,

Could some one please give me an example

 

[JimInKS]

The windows NT help system has more info on the AT command. I am definitely not an expert on this, but...

I would create a batch file to perform whatever task you want to automate. Then schedule the batchfile to run whenever you want. Something like this:

AT 2:00 /EVERY:M,T,W,Th,F,S,Su c:\util\at_test.bat

Will schedule the batch file at_test.bat to run at 2 AM every day of the week.

If you just type the command AT, you will get a listing of scheduled jobs.

I usually like to put an entry in the batch file like:
date /t >> c:\util\at_test.log
time /t >> c:\util\at_test.log
So I have a log of the date and time the batchfile ran.

 

[beetee]

G:\>help at > temp.txt
The AT command schedules commands and programs to run on a computer at
a specified time and date. The Schedule service must be running to use
the AT command.

AT [\\computername] [ [id] [/DELETE] | /DELETE [/YES]]
AT [\\computername] time [/INTERACTIVE]
[ /EVERY:date[,...] | /NEXT:date[,...]] "command"

\\computername Specifies a remote computer. Commands are scheduled on the
local computer if this parameter is omitted.
id Is an identification number assigned to a scheduled
command.
/delete Cancels a scheduled command. If id is omitted, all the
scheduled commands on the computer are canceled.
/yes Used with cancel all jobs command when no further
confirmation is desired.
time Specifies the time when command is to run.
/interactive Allows the job to interact with the desktop of the user
who is logged on at the time the job runs.
/every:date[,...] Runs the command on each specified day(s) of the week or
month. If date is omitted, the current day of the month
is assumed.
/next:date[,...] Runs the specified command on the next occurrence of the
day (for example, next Thursday). If date is omitted, the
current day of the month is assumed.
"command" Is the Windows NT command, or batch program to be run.

 

[mp9]

Alternatively you could try the freeware Handy Access Launcher utility which lets you schedule compacts, repairs and macro runs. Read more about it at

http://www.geocities.com/waddly/accory.html

or

http://www22.brinkster.com/accessory/resources/001.shtml

http://www22.brinkster.com/accessory/

 

[JimInKS]

Click on the Start menu, then Help, to open Win NT Help. Select the Index tab. Type AT COMMAND, click on Display. You should get 3 Topics Found, very helpfully labeled Untitled #0, Untitled #1, and Untitled #2. Try perusing those selections.

 

[withoutaclue]

thanks to every one who posted a suggestions,

they were all very helpful

 

[oharab]

One thing you need to be aware of is that AT and the scheduler will not let you run the files unless you are logged in, this would mean you would have to be logged on 24/7, which is something IT types try to avoid.
That said, you could put a few lines of code that shut down your machine when it is finished.

hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------