Linked Server

I want to setup a linked server to MS Access.
If my MS Access file in different machine, on EM, once I got into the New
Linked Server page, General tab, what should I enter to the boxes:
Product name, Data source and Provider string ?
Have a look in BOL for sp_addlinkedserver, EG
EXEC sp_addlinkedserver
@.server = 'SEATTLE Mktg',
@.provider = 'Microsoft.Jet.OLEDB.4.0',
@.srvproduct = 'OLE DB Provider for Jet',
@.datasrc = 'C:\MSOffice\Access\Samples\Northwind.mdb'
GO
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Is @.server arbitrary ? Any string can work ?
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uZEcigd5FHA.552@.TK2MSFTNGP10.phx.gbl...
> Have a look in BOL for sp_addlinkedserver, EG
> EXEC sp_addlinkedserver
> @.server = 'SEATTLE Mktg',
> @.provider = 'Microsoft.Jet.OLEDB.4.0',
> @.srvproduct = 'OLE DB Provider for Jet',
> @.datasrc = 'C:\MSOffice\Access\Samples\Northwind.mdb'
> GO
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Yes
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)