Linked server to MS Access

• peygham

  Right there with Babe

  Points: 757

  More actions

  February 1, 2007 at 2:22 pm

  #176688

  Hello All,

  I'm trying to create a new linked server through EM on a client machine connecting to an access app on the second server.  When on server 1, I can get connected to the app on server 2 but when on the client machine I get error 7399le db provider....IDBInitialize::Initialize returned 0X800004005:  error.

  Any help will be appreciated.

• David Scotland-132255

  SSCertifiable

  Points: 5599

  More actions

  February 1, 2007 at 3:50 pm

  #687249

  I think this should help

  http://support.microsoft.com/?kbid=814398

  hth

  David

• peygham

  Right there with Babe

  Points: 757

  More actions

  February 2, 2007 at 6:23 am

  #687391

  Thank you David,

  But before I try that work around, why am I able to make the linked connection from server 1 to server 2 (access app) but not from my pc.  I'm using EM to create the linked server.  If it is a permission issue wouldn't it also apply to both scenarios?

  Thanks again,

   

• peygham

  Right there with Babe

  Points: 757

  More actions

  February 2, 2007 at 8:05 am

  #687431

  Could not get it to work so I cheated.  Created an Access DB on local drive on server 1 that pointed to the Access App on server 2.  Now it works!