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.

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.

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

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

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!

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

Thanks,

Michael

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

http://www.mac-net.com/1478083.page