I tried to make one with following options in enterprise manager:
Server type: Other data source
Provider name: test
Product name: Access 2000
Data source: c:\db\test.mdb
Provider string: Microsoft.Jet.OLEDB.4.0
When I try to access the linked server tables I receive following error:
Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
When I try to make a view (select * from linkedserver1...table) I receive following error:
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: Disk or network error.]
Can anyone help me? the only thing I want to do is link an access table to SQL Server (NOT sql server table in access but access table in sql server!)