Running .CMD files from Access

[Stephen sjw_ost]

I have created .CMD files to perform various functions like copy files for my
AutoFEUpdater.
What I want is to make a single access point, an Access Form \ Buttons, for
my users so that I can give them options as to which .CMD file to run.

When I do this with Access using the following code;

Application.FollowHyperlink "K:\Uploader.cmd"

I get a pop up that says;

? Opening K:\Uploader.cmd
Some files can contain viruses or otherwise be harmful to your computer.
It is important to be certain that this file is from a trustworthy source.
Would you like to open this file. OK CANCEL

When I or my user clicks OK the .CMD file runs perfectly and the appropriate
function is carried out.

I created the .CMD files and have successfully tested them and have verified
that they are not harmful. How can I run my .CMD file from access and prevent
this pop up from showing when it is ran from a button in an access form.

Thanks for any help.

 

[Stuart McCall]

I have created .CMD files to perform various functions like copy files for
my
AutoFEUpdater.
What I want is to make a single access point, an Access Form \ Buttons,
for
my users so that I can give them options as to which .CMD file to run.

When I do this with Access using the following code;

Application.FollowHyperlink "K:\Uploader.cmd"

I get a pop up that says;

? Opening K:\Uploader.cmd
Some files can contain viruses or otherwise be harmful to your computer.
It is important to be certain that this file is from a trustworthy
source.
Would you like to open this file. OK CANCEL

When I or my user clicks OK the .CMD file runs perfectly and the
appropriate
function is carried out.

I created the .CMD files and have successfully tested them and have
verified
that they are not harmful. How can I run my .CMD file from access and
prevent
this pop up from showing when it is ran from a button in an access form.

Thanks for any help.

Instead of Application.FollowHyperlink, use the Shell function:

Shell "K:\Uploader.cmd"

 

[dymondjack]

Use ShellExecute instead

http://www.mvps.org/access/api/api0018.htm


--
Jack Leach
www.tristatemachine.com

- "First, get your information. Then, you can distort it at your leisure."
- Mark Twain