Solved

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

Posted on 2009-05-18
5
3,575 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

628 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