• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3796
  • Last Modified:

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

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
shariqsaeed
Asked:
shariqsaeed
1 Solution
 
peter57rCommented:
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
 
shariqsaeedAuthor Commented:
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
 
rockiroadsCommented:
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
 
shariqsaeedAuthor Commented:
yes, i have open another place becasue here they didnt reply.
0
 
sealjoyCommented:
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now