I have an access mdb file in a pc that named "FT-PC" . i tried to connect to this database with sql server 2008 r2 throught this script :
EXEC sp_addlinkedserver @server = 'Ft_link',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = '\\FT-PC\database\ft.mdb'
when i connecting to the server with windows authentication mode , i have access to the data of my created link server but when i connecting with sql server authentication mode (with sa user) , i can't access to the linked server with 7399 error .