Post reply

Linked Server to an Access DB

  • April 25, 2002 at 1:57 pm

    #78792

    Hello,

    How would I create a linked server connecting an Access DB on a remote server, I have been getting OLE DB errors. I created both ODBC and udl datasources and tried to use them, it keeps on failing.

    Please help

    Thanks

    Raghu


    Raghu

  • April 25, 2002 at 3:36 pm

    #427900

    I believe this is due to permissions on the remote server as you have to have an account that SQL is running that is also the same on the remote server, which I believe has to be also on ther same domain or ADS. If you run it locally should work fine.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply