Access error code 2950

Question

Am using the SetValue Macro action to hide the form header when opening the form;  has worked fine in Access 2003, but I get the following error message in 2007:

"Access failed to evaluate one or more expressions because 'Section' was referenced in an expression. Only functions and properties that are considered safe are allowed in expressions when Access runs in sandbox mode"

I am running under Windows XP professional.  I have opened the database from a "Trusted Location" set up in Access Options. Have even tried allowing all macros in the Trust Centre Macro settings. Have also tried converting the database to 2007 format and opening that version.

This has happened to all databases I have previously created for various clients whereever I have attempted this particular SetValue action

Answer 1

Your reply is many years late.

Also you have missed the whole point of the discussion, which was not to do with setting up trusted locations.  It was to do with one small aspect of an Access Macro not working, even when the macro was built with Access' own inbuilt expression builder.  (Namely hiding the header section of a form)

All the steps you have outlined are about databases as a whole, and which I had already attended to when setting up my databases and deciding where to locate them.  My databases were already in Trusted Locations.  My databases opened, worked, allowed me to use and modify them, create macros - everything.

Just this one bug in Access that wouldn't allow me to do something I had been doing for years - use a macro to head the header section in a form when I didn't want that part of the form visible.

Answer 2

Just had another thought...

Try creating a new database and import all your objects into it.  Please be sure to untick Track Autoname Correct and Compact on Close.

---

--

Gina Whipp

2010 Microsoft MVP (Access)

Please post all replies to the forum where everyone can benefit.

Answer 3

Hmmm, is Track AutoName Correct unchecked?  And while you're at it have a look at your References and make sure they are all okay.

Also, what is the 'Section' the error is refering to?  Plerhaps it would help to see the steps in your macro, please post those here...

---

--

Gina Whipp

2010 Microsoft MVP (Access)

Please post all replies to the forum where everyone can benefit.

Answer 4

Yes I have installed that service pack.

To make sure, I just attempted to download and reinstall, and during the install progress received a message that this service pack is already installed.

Answer 5

Have you installed all the SP's?  This was fixed with the release of the first one.  See...

http://support.microsoft.com/kb/942378

---

--

Gina Whipp

2010 Microsoft MVP (Access)

Please post all replies to the forum where everyone can benefit.