Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to eliminate the "open file" security warning

Posted on 2007-11-24
2
Medium Priority
?
518 Views
Last Modified: 2010-04-19
Running SBS 2003 Premium on a HP ML 150 server.
I have installed Office 2000 (only Word, Excel and Access) on this server.
Each time I open an Access mdb file, SBS displays a security warning asking if I want to open this file.  '
How do I tell SBS 2003 not to display this warning all the time?
0
Comment
Question by:donpick
2 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 total points
ID: 20344447
Open Access.
Menu ... Tools>>Macro>>Security...
Set to Low.

mx
0
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 20347430
Digitally sign your files with a commercial security certificate (I got mine from Comodo: www.instantssl.com), then deploy your files with that cert attached. Make sure your workstations are running the correct version of Jet (SP8) and that they correctly turn on Sandbox mode.

Here's more info on it:
http://office.microsoft.com/en-us/access/HA011225981033.aspx
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question