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