G
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.
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.