Solved

How to eliminate the "open file" security warning

Posted on 2007-11-24
2
507 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

747 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now