Gettint the data from an Access data base table from SQL Server 2005

See more:

SQL-Server-2005

SQL-Server

, +

hi guys
i have a table in access and i want to get the data from this table using a query from Sql2005 and i found that i should create a server and i do that but an error come from when i trying to get the data and this is the code

EXEC sp_addlinkedserver
@server = 'AccessDB',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = 'C:\Path\to\Access\Database.mdb'
GO

...............

<pre lang="sql">
SELECT *
FROM OPENQUERY(AccessDB,'SELECT * FROM DPI Crosses')

the error is

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "AccessDB" returned message "'C:\Path\to\Access\Database.mdb' is not a valid path.  Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "AccessDB".