Solved

How to eliminate the "open file" security warning

Posted on 2007-11-24
2
509 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 - Access MVP) earned 250 total points
ID: 20344447
Open Access.
Menu ... Tools>>Macro>>Security...
Set to Low.

mx
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

806 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