scheduling issue

[Guest]

This may be a script question, but since I got the syntax from this
newsgroup, I will continue. I'm trying to schedule a macro to run and this
is my code:

C:> AT 3:05PM "\\CLEVELANDPOINT\IBI\APPS\BASEAPP\TEST.MDB" /X UPLOAD

For some reason, it's just not working and I can't get any kind of error
message or anything. Anyway, I think that the "/X" syntax tells DOS to run
the UPLOAD macro. All that macro does is run a query, though. I was
wondering if anybody has a link to other "/X" type commands that I can look
through. Also, if you can see anything wrong with my syntax, please help!
Thanks!

 

[Douglas J. Steele]

/X is a command-line switch for msaccess.exe, so you need to include the
full path to msaccess.exe in your command.

 

[Guest]

Like douglas said you need to include something like

Call Shell("""C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE""
""C:\MyDocuments\Test.mdb""/XUPLOAD", 1)

As for the time scheduling - I am very lazy (when possible) so I would
simply add the time in the condidtion of the macro but of course I would
never advise anyone to be lazy. As an example (which would be lazy so not to
be done - you "could" forget all the code and simply run a RunApp macro when
the time hits a certain time etc etc etc)

Have fun

 

[Guest]

Thanks guys. I'm going to be lazy and ask if there is a link I can get to to
learn more about these application command-line switches. I changed my code
to:

AT 1:35PM "%PROGRAMFILES%\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE"
"\\CLEVELANDPOINT\IBI\APPS\BASEAPP\TEST.MDB" /X UPLOAD

and it worked great!! But instead of just blindly copying syntax from other
posts, I would really like to know what I'm typing and why! Thanks again!

 

[Douglas J. Steele]

Do a search for "command-line" in the Help file.

 

[Guest]

Yeah, thanks Douglas. I really was being extremely lazy. I did a search for
it a few minutes ago and found exactly what I was looking for. Thanks for
the response, though.

 

[Guest]

Hey,
I'm running into an Access issue when I schedule the AT job. When I do the
interactive option, Access error box comes up saying that it could not find
the specified path name to the database. However, I know it exists and I've
checked it multiple times. Any ideas? However, when I try it on another
server, it works.