Solved

The "Set Value' Macro action cannot be run in disable mode. in MS Access 2007

Posted on 2009-05-18
5
3,382 Views
Last Modified: 2012-05-07
Hi,

I have MS Access 2007 file when i open, I got Security Warning in top there is button Options... when i click there, inside there are 2 option
Help protect me from  unknows content (recommended)
Enable this content

when i select " Enable this contect " i got error, you can see that error in screen shot 3.

but same file is working well another pc. how i can fix.
2.jpg
3.jpg
1.jpg
0
Comment
Question by:shariqsaeed
5 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 24410663
According to your screen shots, you did NOT choose the option to 'Enable this Content'.  The security warning bar is still showing in screen shot 3.
0
 

Author Comment

by:shariqsaeed
ID: 24410737
when i choose security Option > enable this content then i get this Error which is in screen shot.
foget all thing when i open file > chose Security Alert Option > select " Enable this contenct" when press ok i got this erorr. which is attached.
 

Pic-4.jpg
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 24410811
Change your trust settings, see if that helps initially

Click the office button on top right then select Access Options
then select Trust Center and click on Trust Center Settings
In Macro Settings, Enable All Macros
In Trusted Locations, you could try adding your path where the db is or click on "Allow Trusted Locations on my network"


Have u got a similar question to this?
0
 

Author Comment

by:shariqsaeed
ID: 24411139
yes, i have open another place becasue here they didnt reply.
0
 

Expert Comment

by:sealjoy
ID: 28461269
I have a db on a work computer, would like to put it on the network.  I have both the network and my computer location as trusted sources, and also have enabled all content.  I tried adding the registry key, but still my Access 2007 DB will not run the macro with the "SetValue" option.  I still get the "disabled mode" error any help?
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question