EXECUTE sp_addlinkedserver 'North', 'OLE DB Provider for Jet',

'Microsoft.Jet.OLEDB.4.0','C:\Practice Files\Northwind.mdb'

Msg 15028, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 89

The server 'North' already exists.

SELECT * FROM North...Customers

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked...

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "North" returned message "The Microsoft Jet database engine cannot open the file 'C:\Practice Files\Northwind.mdb'. It is already opened exclusively by another user,...

Well, it didn't display any error messages, so I suppose that it worked.

1. Check if the file "C:\Practice Files\Northwind.mdb" exists on the location on your local machine

This file is in this location

2. Check the service account has permissions on the file (go...

Thanx Ramesh, but I don't know how to do this as Sql Server is on my local machine.