Problem querying Linked Server on Access DB

[whool]

Im running SQL 2K. Have created a Linked Server for an Access database. This seems ok in that i can see the tables listed under the linked server in Enterprise mangager. However when I go to run a select query for the Linked DB I get

Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'msysobjects'. The OLE DB provider 'Microsoft.Jet.OLEDB.4.0' indicates that the object has no columns.

But The columns DO exists.

Even if i query Select * from LinkedServer...msysobjects
i get the same error.

Any help appreciated,.

Yael

 

[wsmall73]

Try Select * from LinkedServerName.DataBase.dbo.Table