Linked Access MDB Question

• kbeech

  SSC-Addicted

  Points: 420

  More actions

  April 28, 2004 at 2:58 pm

  #82746

  In the past I have been able to use SQL 2000 to Link to Access Databases.  But today I used Linked Server to Link a new Access Database, and I get the following message when I try and to access a table from the new Linked MDB.

  The OLE DB provider 'Microsoft.Jet.OLEDB.4.0' indicates that the object has no columns. 

  Has anybody seen this message before.

   

  Thanks

   

   

   

   

   

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  April 29, 2004 at 6:40 am

  #504653

  The only time I have seen it is when attempting INSERT / UPDATE via OPENQUERY

  Far away is close at hand in the images of elsewhere.
  Anon.