|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Error 2950 - Related to Trust Center?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. On Wed, 6 May 2009 08:41:01 -0700, GWH <G**@discussions.microsoft.com>
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 Show quoteHide quote >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. 
Other interesting topics
Synchronizing secured replicas
Security problem with Admin password How to Password for Open in Exclusive Mode Establishing a Password for a Delete Button user-level security and splitting database One-Step Security Wizard wont open file Access 2007 "compact and repair" asking password User locked out Logout/login w/o closing Access enabling macros |
|||||||||||||||||||||||
