servers

I used the stored procedures sp_addlinkedserver and sp_addlinkedserverlogin to add an Access db as a linked server. When I try and run SQL commands to this linked Access db I get the following error message:

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ]

Has anyone run into this before?This error message may indicate that the linked server does not have correct login mapping. You can execute the sp_helplinkedsrvlogin stored procedure to set the login information correctly. Also check to make sure you have the correct parameters specified for the linked server configuration.