Solved

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

Posted on 2011-09-09
1
299 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

786 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