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

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.
Similar Threads
  1. AJ

    Trust Certificate

    AJ, Jun 1, 2004, in forum: Access Security
    Replies:
    0
    Views:
    109
  2. Athena

    VBA related

    Athena, Aug 13, 2004, in forum: Access Security
    Replies:
    2
    Views:
    98
    Guest
    Aug 13, 2004
  3. AccessNovice

    trust access to visual basic in access 2003

    AccessNovice, Sep 12, 2005, in forum: Access Security
    Replies:
    1
    Views:
    166
  4. AccessHar

    Trust Center Settings, can this be turned off

    AccessHar, Aug 13, 2007, in forum: Access Security
    Replies:
    1
    Views:
    144
    Scott McDaniel
    Aug 13, 2007
  5. Lloyd

    Trust Center Issue

    Lloyd, Oct 7, 2008, in forum: Access Security
    Replies:
    2
    Views:
    141
    Tony Toews [MVP]
    Oct 12, 2008
  6. June

    Trust Center - Error Message

    June, Mar 5, 2009, in forum: Access Security
    Replies:
    0
    Views:
    159
  7. ddaccess

    OLE Object error in Trust Center

    ddaccess, Apr 23, 2009, in forum: Access Security
    Replies:
    0
    Views:
    344
    ddaccess
    Apr 23, 2009
  8. Owl

    Trust not working so macros fail

    Owl, Oct 22, 2009, in forum: Access Security
    Replies:
    1
    Views:
    122
    Arvin Meyer [MVP]
    Oct 23, 2009
Loading...