UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Is there anyway around having to enable macros in Access 2007, Office 2007    
 
   
teabags
post Jun 25 2010, 07:25 PM
Post #1

UtterAccess Veteran
Posts: 419
From: Ireland
Hello,

I want to split an access db and set up the front end so the user dosen't have to enable macros or vba because of the trust settings.

Is there anyway around having to enable macros in Access 2007?

Thank you.
Go to the top of the page
 
+
GroverParkGeorge
post Jun 25 2010, 07:37 PM
Post #2

UA Admin
Posts: 19,250
From: Newcastle, WA
In order to do any work with macros or VBA, macros and VBA need to enabled.

You can't enable them yourself because the whole idea of trusted locations is that the user must make that decision, not you and your database.
This Link might be a bit of overkill for your purposes, but it might give you some pointers and questions to ask your network support people.

George
Go to the top of the page
 
+
HiTechCoach
post Jun 25 2010, 09:35 PM
Post #3

UtterAccess VIP
Posts: 18,396
From: Oklahoma City, Oklahoma
QUOTE (teabags @ Jun 25 2010, 07:25 PM) *
Hello,

I want to split an access db and set up the front end so the user dosen't have to enable macros or vba because of the trust settings.

Is there anyway around having to enable macros in Access 2007?

Thank you.


I would recommend using this to deploy your front end:

Auto Fe Updater

QUOTE
Q: My users are getting the Access 2007 Security Warning - Certain content in this database has been disabled? Is there anything that can be done.
Access 2007 Security Warning - Certain content in this database has been disabled.
A: In the Auto FE Updater program Update the configuration file and select Trusted Locations screen. Then click the check box appropriate to your version of Access.
Go to the top of the page
 
+
teabags
post Jul 19 2010, 06:49 PM
Post #4

UtterAccess Veteran
Posts: 419
From: Ireland
QUOTE (HiTechCoach @ Jun 26 2010, 03:35 AM) *
I would recommend using this to deploy your front end:

Auto Fe Updater


Thank you for your reply.

Is autofeupdater free?

Thank you.
Go to the top of the page
 
+
HiTechCoach
post Jul 19 2010, 07:05 PM
Post #5

UtterAccess VIP
Posts: 18,396
From: Oklahoma City, Oklahoma
QUOTE (teabags @ Jul 19 2010, 06:49 PM) *
Thank you for your reply.

Is autofeupdater free?

Thank you.


You're welcome!

From the first two paragraphs at the autofeupdater link:
QUOTE
Want an easy way to distribute updates to the users of your Microsoft® Access® front end? Tired of visiting each users PC to roll out a new version of an Access® front end? Weary of explaining to each of the users how to use Windows Explorer to copy the new FE from the server to their PC; And then fixing up the mistakes they inevitably make. And how to get the FE to a new user?

This process is exactly what the Auto FE Updater is designed to do. And it's free. ...
Go to the top of the page
 
+
teabags
post Jul 20 2010, 03:34 AM
Post #6

UtterAccess Veteran
Posts: 419
From: Ireland
QUOTE (HiTechCoach @ Jul 20 2010, 01:05 AM) *
You're welcome!

From the first two paragraphs at the autofeupdater link:

Hello,

Thank you for your reply.

I am having trouble with the trust centre set up on autofeupdate.

I click the check box to allow trusted locations but it dosent work.

Any ideas where I am going wrong?

Thank you.
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 08:32 PM