Unanswered: Creating linked server to access an Access db
I am trying to access an mdb (Access) file from SQL Server.
Using Query Analyser:
I called the system stored procedure to link the db:
sp_addlinkedserver 'DB1', 'Access 2002', 'Microsoft.Jet.OLEDB.4.0', 'c:\DBTest\db1.mdb'
Then tried to read data from the linked source (customer is a table in the Access file):
select * from DB1...customer
I got this error msg:
Server: Msg 7357, Level 16, State 2, Line 3
Could not process object 'customer'. The OLE DB provider 'Microsoft.Jet.OLEDB.4.0' indicates that the object has no columns.