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.