W2k3 Won't open Access files w/o prompt??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've upgraded a test server to w2k3 standard edition. I need to automatically run an Access db every day that runs an auto query to update some other dbs on our network then auto shutdown the Access db. I've setup the db to do auto run the queries once opened, then, auto shut down, not a problem. The problem is when I try to open it automatically using the task scheduler I get a prompt indicating that this could be a dangerous file and wants me to click "Open" , "Cancel" or "Help" . This is all fine except the entire concept hinges on everything happening automatically. The only snag is this prompt.

If I click the "Help" button it brings me to this Win Help File:
****************************************
Downloading files
Some files contain viruses or can otherwise harm your computer.

If you run a program or open a file directly from a Web site and it causes your computer or other programs to shut down, you could lose unsaved work in any open files on your computer.

If you save this file or program to disk, you can run it later. This allows you to take precautions, such as the following, before you open the file or run the program:

Check the file with a virus scanner.
Save your work and close other programs.
Disconnect from the Internet or any other network connections.
For the most security, make sure the Always ask before opening this type of file check box is selected. If you feel confident that this type of file or program is always safe to open or run directly from the Internet, make sure this check box is cleared.

Note

The Always ask before opening this type of file check box is not available for some file types, such as files with the extensions .exe or .com, which run programs or commands. When this check box is not available, you will always be asked before opening this type of file.
****************************************

This is all well and good, but I want to disable the prompt if I'm using the task scheduler to automatically open the db so the queries will auto run and the app will just shut down, all without any user action being performed manually. Can anyone point me to a line of code that will disable this functionality so I can use the scheduler or any other tips that might work?

Thanks all,
Bernadou
 
I believe you need to set macro security to Low. Not sure where you do this,
though. Also not sure whether you can actually run an Access app as a
service? Maybe use the /nostartup flag (or whatever it is) to suppress the
Access startup flash screen - because a service does not have a usable
visual interface (AFAIK).

HTH,
TC


Bernadou said:
I've upgraded a test server to w2k3 standard edition. I need to
automatically run an Access db every day that runs an auto query to update
some other dbs on our network then auto shutdown the Access db. I've setup
the db to do auto run the queries once opened, then, auto shut down, not a
problem. The problem is when I try to open it automatically using the task
scheduler I get a prompt indicating that this could be a dangerous file and
wants me to click "Open" , "Cancel" or "Help" . This is all fine except the
entire concept hinges on everything happening automatically. The only snag
is this prompt.
If I click the "Help" button it brings me to this Win Help File:
****************************************
Downloading files
Some files contain viruses or can otherwise harm your computer.

If you run a program or open a file directly from a Web site and it causes
your computer or other programs to shut down, you could lose unsaved work in
any open files on your computer.
If you save this file or program to disk, you can run it later. This
allows you to take precautions, such as the following, before you open the
file or run the program:
Check the file with a virus scanner.
Save your work and close other programs.
Disconnect from the Internet or any other network connections.
For the most security, make sure the Always ask before opening this type
of file check box is selected. If you feel confident that this type of file
or program is always safe to open or run directly from the Internet, make
sure this check box is cleared.
Note

The Always ask before opening this type of file check box is not available
for some file types, such as files with the extensions .exe or .com, which
run programs or commands. When this check box is not available, you will
always be asked before opening this type of file.
****************************************

This is all well and good, but I want to disable the prompt if I'm using
the task scheduler to automatically open the db so the queries will auto run
and the app will just shut down, all without any user action being performed
manually. Can anyone point me to a line of code that will disable this
functionality so I can use the scheduler or any other tips that might work?
 
Back
Top