Welcome to SPN

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

Sign Up Now!

Error When Linking To Remote Database

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

  1. RWB

    Expand Collapse

    I'm in a .adp access database trying to use the Link Table Wizzard to Link a
    SQL database table (not in the current database).

    On the first screen of the wizzard, the Linked Server is dimmed, the
    TransactSQL option is checked - which is fine.

    I think click the New Source button and pick Microsoft SQL Server. I enter
    a Server Name and select Windows Authentication.

    On the next form, I find the database I want and I find and select the
    specific table I want within the database. Everything still fine.

    On the next form, I enter a name of file for the Data Connection to Save and
    Finish to - it defaults to a .odc file extension.

    On the next form I select the datasource I just saved and click Open.

    On the next form I select the 2 tables that I want and click Next.

    the next form has a message - " The link table wizzard has all the
    information it needs to create a Microsoft SQL Server view for each table you
    have chosen"
    On this form I click Finish.

    I then get the error - "Access to remote server is denied because no
    login-mapping exists"

    Soooooooooo what the heck it goes all the way through looking like it will
    work and then fails when it seems oh so close? thanks in advance
  2. Loading...

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page