Create a linked server to an access database

[Xenon54]

Is it possible to create a linked server in SQL Server 2000 to an Access Database?

I tried to make one with following options in enterprise manager:

Server type: Other data source
Provider name: test
Product name: test
Data source: c:\db\test.mdb
Provider string: Microsoft.Jet.OLEDB.4.0

When I try to access the linked server I made I receive following error:
Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.

Any suggestions?

 

[sguslan]

Hope this helps :

http://www.sqlmag.com/Forums/messageview.cfm?catid=8&threadid=5554

 

[Guest_imported]

Hi,

I am able to connect to the Access database without error if it is on my C drive, but when it is on the network and I configure my registry to point to the system.mdw on the network, and the linked server to be look up the Access database on the network, the database tables are not visible and I get the error.

Is there any solution to this problem.

Regards,
VEnkat

 

[Xenon54]

I already solved the problem.

The database was local, so I made a share to it and I used \\server\database.mdb as datasource in stead of c:\database.mdb