Linked Server to an Access DB

• raghu_nandan1

  SSC Eights!

  Points: 966

  More actions

  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

• Antares686

  SSC Guru

  Points: 125444

  More actions

  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)