Solved

How to eliminate the "open file" security warning

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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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…

840 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