AT command Access macro schedule

[Guest]

Can anybody help with this:
When I run number 1, it runs fine, but number 2, gives me an Access error
that says that Access can't find the specified file.

1) "%PROGRAMFILES%\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE"
"\\HORSEISLAND\NETSHARE\MEDICAL\OOQ\APPS\ASU\MARK_TEST.MDB" /X UPLOADMACRO

2) AT 9:00AM /INTERACTIVE "%PROGRAMFILES%\MICROSOFT
OFFICE\OFFICE\MSACCESS.EXE"
"\\HORSEISLAND\NETSHARE\MEDICAL\OOQ\APPS\ASU\MARK_TEST.MDB" /X UPLOADMACRO

Thank you!

 

[John Nurick]

Hi Mark,

AIUI, AT wants a command consisting of a single quoted string and won't
accept a command line consisting of a command with various filespecs and
switches. The Windows command processor isn't very sophisticated and I
this that it would parse /X UPLOADMACRO as a switch for AT.EXE rather
than as part of the command to be executed by the task scheduler.

The usual workround is to create a batch or script file containing the
actual command line(s) you want the scheduled task to execute, and to
use the filespec of this in the AT command.

Hope this helps.

 

[Guest]

Thanks for your response, John. So, if I make a text file consisting of
nothing but the:

"%PROGRAMFILES%\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE"
"\\HORSEISLAND\NETSHARE\MEDICAL\OOQ\APPS\ASU\MARK_TEST.MDB" /X UPLOADMACRO

then that should work? I'm going to try and fiddle with it and see if I can
get it to work. Thanks! I've been trying to get this right for some days
now.

 

[John Nurick]

Give it a try. The file should have the .CMD extension (or .BAT if
you're using an antique version of Windows).

 

[Tony Toews [MVP]]

The usual workround is to create a batch or script file containing the
actual command line(s) you want the scheduled task to execute, and to
use the filespec of this in the AT command.

Ah, excellent point. I do the same on my webserver mostly because I
can't remember the syntax every time I need to reset things. So now
I just have those commands in a .cmd file and click on it.

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

 

[aaron.kempf]

you guys are ****ing retards

SQL Server has a SCHEDULER built into it that is about a billion times
more powerful

lose the training wheels or STFU and go and play with your barbies

-Aaron