Trust access to VB Project

[Guest]

In Access 2003 - going to tools, macro, security, trusted publishers tab -
would like to check the box the "Trust access to Visual Basic Project" but it
is grayed out. I found this in one of the Google discussion groups - it
pertains to Excel but thought it might also pertain to Access.

When your app is running as a service, the following key must be altered
programmatically.
HKEY_LOCAL_MACHINE\SOFTWARE\Po­licies\Microsoft\Office\10.0\E­xcel\Security
Dword "AccessVBOM"
If the key doesn't exist, it defaults to zero (do not allow access)
Create it if necessary and change the value to 1 (allow access)

Under Access, there was not a folder for Security (not under Excel either).
I created key called "Security" and then a value for AccessVBOM and set the
value to 1. That still didn't make the box available.

Anyone know how to make that box available???

 

[Sylvain Lafontaine]

You cannot set/unset this value under Access because it make no sense to do
so with Access. Contrary to Word or Excel, where you can have documents
that can be displayed and manipulated without any access to vba code, you
cannot have this with Access (there is no notion of something like
"ActiveDocument" with Access).

Even the simplest MDB databases will require some code manipulation by
Access when you want to display data by opening a table or running a query.

 

[Guest]

I am not trying to display data in a table by changing registry keys. When
going to Tools, Macro, security and clicking on the tab for Trusted
Publishers - I need to be able to click the check for for "Trust access to
Visual Basic Project." This option is grayed out. I have seen tons of posts
asking this same question - how to make that option available - am just
looking for someone that can answer this question.

 

[Sylvain Lafontaine]

This option is to block access to CurrentDocument.VBProject for some Office
Applications such as Word and Excel but there is no CurrentDocument nor
VBProject objects under Access; so why do you want to be able to click this
check under Access?

 

[Guest]

We create Excel spreadsheets while in our Access application using VBA. While
doing so we generate macros in the Excel spreadsheet, because of the nature
of our data this needs to be dynamic so we cannot use a template xls. The
macros are used with selections made to listboxes or other interactive
objects the customer might require.

 

[Sylvain Lafontaine]

I don't know how you are creating your Excel spreadsheets from inside
Access; however I seriously doubt the possibility that changing an Access'
specific setting would have any effect on the security level of Excel;
particularly if you are using Automation to create and manipulate your Excel
spreadsheets. Otherwise, setting this value inside Excel would be nearly
totally useless.