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
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