Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page