Sula Dunklin
New member
- Local time
- Today, 03:25
- Joined
- Oct 3, 2008
- Messages
- 6
Good afternoon. I created a software using Access2000, converted it to Access 2007, packaged it as an executable with Access 2007 Runtime. The program has an auto executable that runs a macro upon startup. Microsoft 2007 automatically blocks macros disabling their functionality unless trusted. The error code is 2950. The problem is that if the user doesn't have Access 2007 on their computer, they can't trust the database location. I used the sample code below given to create a script to automatically trust the file, replacing the path with the location that my software is installed.
The problem is that it didn't work. The error remains and when I looked in the registry file, the sequence was dropped after the Access connectivity engine folder. So the trusted location was never registered.
Does anyone have any suggestions? Or have a totally confused you.
Thanks for any help.
Access 2007 FAQ
Using Access 2007 Runtime, how can I create a Trusted Location if there's no UI to create it?
You'll need to create a script or install routine that manually creates the necessary registry keys.
For example, setting these keys....
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location0]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\AccessJunkiesRule"
...results in this:
The problem is that it didn't work. The error remains and when I looked in the registry file, the sequence was dropped after the Access connectivity engine folder. So the trusted location was never registered.
Does anyone have any suggestions? Or have a totally confused you.
Thanks for any help.
Access 2007 FAQ
Using Access 2007 Runtime, how can I create a Trusted Location if there's no UI to create it?
You'll need to create a script or install routine that manually creates the necessary registry keys.
For example, setting these keys....
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location0]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\AccessJunkiesRule"
...results in this:
