UtterAccess.com
Thank you for your support!      
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Security Warning when opening database    
 
   
JohnL_Duncan
post Jan 30 2006, 10:55 AM
Post #1

UtterAccess Veteran
Posts: 315
From: Pevely, MO



Hello All,

When my users are opening a database with the Access 2003 VIEWER, I get a series of warnings before they can get into the datbase.

The first is Security Warning: Unsafe expressions are not blocked. Do you want to block unsafe expressions?

I click No

Then I get a security warning:
Opening "Path-Filename"

This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation?

I click Open

Then finally it lets me into the database. If this was the full version of Access I could change the security settings, but I can't find the option with the viewer.
Go to the top of the page
 
+
timbailey
post Jan 30 2006, 11:12 AM
Post #2

UtterAccess Veteran
Posts: 252



Basically two choices:

1. Put digital signatures on the database and set the root certificate for the signature as trusted. This will remove the warnings from your database.

2. Access uses two registry keys to hold the security settings. Setting the values below will set security to low.

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines]
"SandBoxMode"=dword:00000002

[HKEY_LOCAL_MACHINE\Software\Microsoft\Office\11.0\Access\Security]
"Level"=dword:00000001

This change is equivalent to setting the security level to low in the full Access package.

Good luck!
Tim Bailey
Energy Laboratories, Inc.
Go to the top of the page
 
+
JohnL_Duncan
post Jan 30 2006, 12:02 PM
Post #3

UtterAccess Veteran
Posts: 315
From: Pevely, MO



Edting the registry seems to take care of the unsafe expressions error, but I am still seeing:

This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation?

I click Open
Go to the top of the page
 
+
khaos
post Jan 31 2006, 11:07 AM
Post #4

UtterAccess Editor
Posts: 8,583
From: Lansing, MI



A couple of UA users who work for Microsoft have posted a lot of good info on this here. Look for Rob Cooper and mwachal. Searching with those usernames and access 2003 should get you what you need.

HTH
Ken
Go to the top of the page
 
+
JohnL_Duncan
post Jan 31 2006, 11:10 AM
Post #5

UtterAccess Veteran
Posts: 315
From: Pevely, MO



I found a database fix on another site. When you open this up it gives you the security options even from the Acess 2003 viewer. Very nice!
Attached File(s)
Attached File  Security Fix.zip ( 7.14K ) Number of downloads: 142
 
Go to the top of the page
 
+
neominds
post Feb 8 2006, 03:47 PM
Post #6

UtterAccess Enthusiast
Posts: 49



Could you provide us with the link to the site? I am needing the same information.

Thanks,

Michael
Go to the top of the page
 
+
JohnL_Duncan
post Feb 9 2006, 08:33 AM
Post #7

UtterAccess Veteran
Posts: 315
From: Pevely, MO



You can get it here or download the attatchment from my previous post.

http://www.mac-net.com/1478083.page
Go to the top of the page
 
+

Reply to this topicStart new topic

 



RSS Go to Top  ·  Lo-Fi Version Time is now: 9th February 2012 - 11:50 AM

Tag cloud: