Solved

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

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
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…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…

863 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