Hey All,

Im trying to build a deployment MSI of a fairly complex Access app for non techncial types to use. The app uses VBA, some ActiveX, and an external ribbon XMl file. I want it to install with the runtime so non Access owning users can use the app.

The problem i am having is that when I install it on a fresh system and try to run it, it comes back with a 2950 error, which MSFT has documented as a trust error when trying to run VBA code.

The MSFt article on the package Solution Wizard says it can add the installed directory as trusted location, but this doesn't seem to be happening and I cant find any flag anywahere to make it happen.

Help??

Addenedum... it doesnt seem to be a trust problem, but as problem in specific calling the RunCode macro operation.

My trust check, which occurs before this in macro sequence, passes fine....

Further info.

VBA scripts run fine in this app. As do macros.

The ONE thing it throws up on is the AutoExec calling RunCommand to run code that installs a ribbon from a file. And it only throws up on it when deployed in the Access Runtime.

Hello Jeff,

The problems I have experienced with Access 2007 runtime seem to relate to unsupported options in runtime like the ability to hide navigation pane if this is hard code. This functionality is not supported by the runtime engine probably because the runtime engine does not display the navigation window.
My suggestion is to look what code you run at start up and take out one segment each time to see which part of the code causes your problem.

Kind regards,

Arkie