Error 2950 - Related to Trust Center?

[GWH]

I am using an .ade file that ties back to a SQL server. The .adp/ade was
developed using Access 2003 and I'm using Access 2007 to open/use the file.
One of the command buttons has a macro and VBA code running on the server.
In Access 2003 it works without error, but 2007 gives me an error 2950. A
google search suggests that this is an issue with a trusted location. So I
used the trust center to make the sever location safe, as far as I can tell.
I still get the error. Of course, the error provides no helpful information
whatsoever including the location/path of the server. I guess that might
make it too easy to fix my problem. Anybody out there know if the trusted
locations can be turned off? I can appreciate that 2007 is more secure than
2003 but I don't like the fact that this security is emposed on me without
the apparent option to disable and that an older version is more flexible
than the new version.

 

[Tom van Stiphout]

On Wed, 6 May 2009 08:41:01 -0700, GWH <[email protected]>
wrote:

In the trust center you need to make the location of the ade trusted,
not that of the server. You *do* have the ade on your local
workstation, per best practices, right? If not, do that right away.

VBA code is not running on the server, but on the workstation.

-Tom.
Microsoft Access MVP

 

[Accessguru901]

This issue occurs if the database is not trusted by Access 2007. By default, Access opens databases that are not trusted in Disabled mode. In Disabled mode, executable content is disabled. There are few methods to solve this error:

First Method: Move the database to a trusted location and determine trusted locations to which you can move the database.
then Click Trust Center, and then click Trust Center Settings under Microsoft Office Access Trust Center and add trusted locations and then specify the path of the location

For more details and step by step procedure::
http://accessguru.net/Articles_MSAccess/0049-Error 2950 How to solve this error.php