Access Runtime 2007

E

elytz

I have installed an aceess program on a machine not running office so I
insalled Access Runtime 2007 on the machine but the macro security settings
and the message of update and adding rscords changed. How can I configure
them on the machine running Access Runtime 2007?
 
B

boblarson

From this thread:
http://www.thescripts.com/forum/thread692003.html

The security system changed in A2007.
You have to determine a Trusted Location (folder) for your accdb.
In full version that's done by adding the place to a list under Access
options. Runtime has no office menu button. So you have to add the folder to
the registry manually adding a locations key, e.g.:

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security\Trusted
Locations\Location1]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\MyTrustedDatabaseFolderNo1"

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security\Trusted
Locations\Location2]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\MyTrustedDatabaseFolderNo2"

--

Bob Larson
Super Moderator - Access World Forums
Access VIP on Utter Access
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Rpts 10/XI, VB6
WinXP, Vista
 
S

Steve Jensen

Hello, Bob
I assume these reg keys can be added to the Package wizard. However, the
user can change the default installation path of the runtime application, so
how can these keys be created to use the installation folder selected by the
user?

boblarson said:
From this thread:
http://www.thescripts.com/forum/thread692003.html

The security system changed in A2007.
You have to determine a Trusted Location (folder) for your accdb.
In full version that's done by adding the place to a list under Access
options. Runtime has no office menu button. So you have to add the folder to
the registry manually adding a locations key, e.g.:

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security\Trusted
Locations\Location1]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\MyTrustedDatabaseFolderNo1"

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security\Trusted
Locations\Location2]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\MyTrustedDatabaseFolderNo2"

--

Bob Larson
Super Moderator - Access World Forums
Access VIP on Utter Access
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Rpts 10/XI, VB6
WinXP, Vista


elytz said:
I have installed an aceess program on a machine not running office so I
insalled Access Runtime 2007 on the machine but the macro security settings
and the message of update and adding rscords changed. How can I configure
them on the machine running Access Runtime 2007?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top