A2K3 and jet Sandbox

R

Roy Ristie

Hi Folks,

My system runs WinXP Pro SP2

I just installed Office2k3 Pro including SP1 and tried to open one of my A2k
mdb's.

To my surprise Access complained about security isues and insisted that I
install Jet4.0/SP8, which I already have installed.

My customers have a mix of A2k and A2k2 installations on WinXP. The status
of service packs UNKOWN (both for os and office).

The apps are distributed in 2k format as split MDE.


My questions:

1. How do I best deal with this issue both personally and with regards to
customers pcs. What I'm looking for here is BEST Practise advice.

2. How can I bypass the warning i.e., where is the toggle to switch it of
located?

Thanks
--Roy--
 
J

Jeff Conrad

Hi Roy,

Here is some info on this subject:
(Watch out for any possible line wrapping on these links)

You can to go Tools, Macro, Security and set it to low.
If the security item isn't on that menu, you may need to reset your menubar. See:
http://support.microsoft.com/default.aspx?scid=kb;en-us;833219&Product=acc2003

You can also manually add the following Registry keys:
Set registry as follows:

ROOT:Local Machine
Key: SOFTWARE\Microsoft\Jet\4.0\Engines
Name:SandBoxMode
Value:#00000002

ROOT:Local Machine
Key: Software\Microsoft\Office\11.0\Access\Security
Name:Level
Value:#00000001

If these are just for your use, you can create a self cert on your computer
and digitally sign your databases. More info at:
http://www.microsoft.com/resources/documentation/office/2003/all/reskit/en-us/seca02.mspx

Other link to see:
http://office.microsoft.com/assista...ID=CH010411421033&CTT=4&Origin=CH010411391033

Frequently asked questions about Access security warnings:
http://office.microsoft.com/assista...ID=HA011225981033&CTT=4&Origin=CH010411391033

More info here:
How to configure Jet 4.0 to prevent unsafe functions from running in Access 2003
http://support.microsoft.com/default.aspx?kbid=294698

Still more info here:
http://www.fmsinc.com/free/tips.html#accesstip19

Another link on the subject:
http://www.access.qbuilt.com/html/vba.html#SetMacroSecLvl

An online course
http://office.microsoft.com/training/training.aspx?AssetID=RC011461801033

--
Jeff Conrad
Access Junkie
Bend, Oregon
Bend's idea of 'Spring Break':
http://www.tripcheck.com/RoadCams/RoadCams_Bend.htm
 
R

Roy Ristie

Thanks Jeff,
I now have some references to consider.
Question is now answered.

Thanks again,
--Roy--
 
Top