Solved

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

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

840 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