Error message about Sand box Modus

[Jan T.]

I am using ms Acess 2k3 and have downloaded a database. When I open
some of the forms, I am having problems. The warning is that some
expressions may not be safe or something. The forms is havely based on
macros and no vba code.

Now, I trust the file I have downloaded. How can I have my Access
tuned to accept those unsafe expressions? Is there a way to turn Sand
Box Modus on and off?

Any help is very much appreatiated.

Regards
Jan

 

[Allen Browne]

On the Tools menu, choose Macros.

Click on Macro Security and set it to Low.

 

[Guest]

I am having the same problem with 2007. I have a database that when opened
in 2003 and macro security set to low - works fine. Can't figure out how to
fix it in 2007. Any experience/Advice?

ST

 

[Allen Browne]

In A2007, you add your database folder to the trusted locations.

Go to:
Office Button | Access Options | Trust Center | Trust Center Settings

More info on converting to the new version:
http://allenbrowne.com/Access2007.html

 

[Guest]

Thanks for the idea. I added the network folder from which I am running the
database and, unfortunately, am still getting the error message. I added the
folder with the full network path. Is that incorrect? What else might I be
missing?

The VB is simply:
docmd.openreport "Name", acViewXxx

Thanks again.

 

[Allen Browne]

If this is an MDB, it may help to set the JET 4 sandbox mode under:
\\HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\engines\SandboxMode

More info:
http://support.microsoft.com/kb/239482

 

[Guest]

I've changed the registry key and still am unable to run the simple VB. I've
even tried the same three tasks on a different machine running Office 2007.
1. Enable all macros
2. Add folder to allowed locations
3. Changed jet registry and set value to 0.
Same error message appears when trying to click a button on a form tied to
docmd.openreport.

I'm open to any further suggestions! Thanks for all your help!

ST

 

[Allen Browne]

VB? You're trying to use an ACCDB from pure Visual Basic (not VBA in
Access)?

If so, try including a reference to:
C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE12\ACEDAO.DLL
instead of the DAO 3.6 library.

 

[Guest]

Apologies! No it IS just VBA. Nothing complex. I've even tried to use the
wizard to recreate the button to open the report (assuming that Access would
create the button with the appropriate VBA code for security settings) still
the same error.

 

[Douglas J. Steele]

The registry key you cited earlier
(\\HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\engines\SandboxMode)
wouldn't be applicable for an ACCDB either, would it Allen?