Linked Server to an Access DB

  • 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




  • 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