I have created a Linked Server to an Access DB with SQL 2005 to a cross server mdb
EXEC sp_addlinkedserver
@provider = 'Microsoft.Jet.OLEDB.4.0 DB Provider',
@product name = 'ACCESS DB',
@data source = '\\server3\datacenter\data1.mdb'
I have successfully created the link and queried the mdb and But when I try to browse the table in the linked server, it prompts me the error
TITLE: Microsoft SQL Server Management Studio
FAiled to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "Data1".(Microsoft SQL Server, Error: 7303)