Error 2950 - Related to Trust Center?

Discussion in 'Access Security' started by GWH, May 6, 2009.

  1. GWH

    GWH Guest

    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.
     
    GWH, May 6, 2009
    #1
    1. Advertisements

  2. On Wed, 6 May 2009 08:41:01 -0700, GWH <>
    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


    >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, May 7, 2009
    #2
    1. Advertisements

  3. GWH

    Accessguru901

    Joined:
    Jul 29, 2014
    Messages:
    2
    Likes Received:
    0
    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
     
    Accessguru901, Jul 29, 2014
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.