Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

ODBC Linking Problem

Discussion in 'Information Technology' started by Joe Williams, Jul 28, 2006.

  1. Joe Williams

    Joe Williams
    Expand Collapse
    Guest

    I have an Access 2002 front end to an SQL 2000 SP4 back end. I have been
    using this application for several years with no issues.

    I have set up an SQL userID that has the proper permissions so that when I
    link to the SQL server, it prompts me for the password adn then I can link
    the appropriate tables and use teh SAVE PASSWORD option.

    THe problem I am having now is that when I try to link one of the SQL
    tables, I am no longer asked for a userID and password. It is automatically
    using the logged in user's password (administrator) and so I cannot enter
    the one I created for the SQL database

    Then, when a user tries to access these tables, the system tries to use
    thier local credentials rather than the SQL username and password that I
    specified and they get an access error.

    So, the question is, why did Access/ODBC stop asking for the username and
    password when linking tables and how do I fix it?

    THanks

    joe
     
  2. Loading...


  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Joe Williams wrote:
    > I have an Access 2002 front end to an SQL 2000 SP4 back end. I have
    > been using this application for several years with no issues.
    >
    > I have set up an SQL userID that has the proper permissions so that
    > when I link to the SQL server, it prompts me for the password adn
    > then I can link the appropriate tables and use teh SAVE PASSWORD
    > option.
    > THe problem I am having now is that when I try to link one of the SQL
    > tables, I am no longer asked for a userID and password. It is
    > automatically using the logged in user's password (administrator) and
    > so I cannot enter the one I created for the SQL database
    >
    > Then, when a user tries to access these tables, the system tries to
    > use thier local credentials rather than the SQL username and password
    > that I specified and they get an access error.
    >
    > So, the question is, why did Access/ODBC stop asking for the username
    > and password when linking tables and how do I fix it?
    >
    > THanks
    >
    > joe


    In your ODBC DSN there is a setting where you can choose between SQL Server
    Authentication (what you want) and Integrated Security / Trusted Connections
    (what is apparently set now).

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     

Share This Page