Need help with linked servers!!!

[TPetersonFlorida]

Could someone please tell me how i can set up a linked server to an MS Access 2000 database??? Thanks a million in advance.

 

[LFCfan]

the following is an example from SQL Server Books Online.
search for sp_addlinkedserver in the Index for the full thing

B. Use the Microsoft OLE DB Provider for Jet
This example creates a linked server named SEATTLE Mktg.

HTH...
------------------------------------------------------

Note This example assumes that both Microsoft Access and the sample Northwind database are installed and that the Northwind database resides in C:\Msoffice\Access\Samples.


USE master
GO
-- To use named parameters:
EXEC sp_addlinkedserver
@server = 'SEATTLE Mktg',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = 'C:\MSOffice\Access\Samples\Northwind.mdb'
GO
-- OR to use no named parameters:
USE master
GO
EXEC sp_addlinkedserver
'SEATTLE Mktg',
'OLE DB Provider for Jet',
'Microsoft.Jet.OLEDB.4.0',
'C:\MSOffice\Access\Samples\Northwind.mdb'
GO

 

[TPetersonFlorida]

Thanks. I did exactly what you had given and it added the server BUT when you go to view the tables it gives the following error:

Error 7399: OLE DB Provider 'Microsoft.Jet.OLEDB.4.0' reported an error.

OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0X80004005: ].


Any ideas???

Thanks!

 

[TPetersonFlorida]

disregard that last post. i figured out that error. But i do have another question. How do i link a table from my SQL Server database to a table in the linked server database????