Solved

ACCESS 2007 Question on Settings for Macro's for Applications placed on Network

Posted on 2011-09-09
1
297 Views
Last Modified: 2012-05-12
I have questions concerning the Access 2007 Application Macro Settings for applications placed out on Network.
Can the settings be made in the application and saved and then placed on the network?
I placed an Access 2007 application on the network and some people are unable to open and use all of the macro buttons.  The macro buttons are disabled and the searches do not work.  I would rather make one setting in the application and save it and then have it work.  Do I have to go to each individuals computer and make the setting to enable macros?

I can go to the Access Opetion and Trust Center/Macro Settings and Enable all macros and all of the buttons then work.

Also I have the enable content appearing at the top whe  the application is first opened on another persons machine the first time.  I want this to go away and not appear.

Please advise.

jjc9809
0
Comment
Question by:jjc9809
1 Comment
 
LVL 4

Accepted Solution

by:
raremind earned 500 total points
ID: 36513868
Are the PC's on a domain? if they are Group policy should take care of you:

http://technet.microsoft.com/en-us/library/ff400327.aspx#proc2

If not, you're out of luck. I have heard of people scripting the policy and make the changes but I have yet to find a solution that actually works. It may be out there though!
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

762 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now