Error 2950 In Access 2007 Runtime From Trusted Location

[Dave]

Hello,

I have searched, without success, for a couple of days now for a
solution to my problem.

I am deploying an Access 2003 database in a network environment using
the 2007 Runtime to run the DB. The front end runs off of the local
computer and the backend off of a network location.

I have both databases in trusted locations that I have added through
the registry. I have enabled network locations. I do not get a prompt
indicating that they are not trusted, which shows me that they really
are in trusted locations.

I have the full version of 2007 on my laptop and get no errors,
however, on the client machine I get a 2950 error in the Autoexec
macro.

I tried moving the function call in the macro into a form that would
launch on startup instead of the macro and still get the runtime
error, however, when I get the error in this fashion I do not get the
error dialog like with the macro, I just get a runtime msgbox.

Any help on this would be greatly appreciated, particularly since I
have come accross two posts with this problem that do not have a
posted answer.

Dave

 

[Dave]

Did you enable the content for the db on the client pc?  Does the code
compile?  What are the folder and file permissions on the client pc forthe
front end and back end?  Read/write/modify?

Chris

Chris,

Thanks for the quick reply.

The code compiles. Both folders and files have complete full
permissions. How would I go about enabling in 2007 Runtime?

Dave

 

[Dave]

If the content isn't currently enabled you'll see a horizontal message bar
under the ribbon.  Click on options.  In Microsoft Office Security Options,
click on "Enable this content" and click ok.

If the content is already enabled, you won't see a message bar.

Chris

Chris,

There is no message bar. Thanks again for all of the help.

Dave

 

[Dave]

Check the registry to see what sandbox mode the client pc is using.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines

Value: SandboxMode = 2

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\
Engines

Value: SandboxMode = 2

Chris

Chris,

I have not heard of this Sandboxmode before, so thank you for teaching
me something new.

I checked, the value is 3. I only found it located in the
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity
Engine\Engines location, not the other. Is it missing?

Thanks again for the vast amount of help.

Dave