- During a transition phase (from Access 2.0 to SQL Server 2000) I am looking
for a way, to easily access an Access 2 *.mdb from SQLServer 2000. Actually
I want to use the data, which are originally changed in Access in SQL Server,
kind of a one-way synchronization.

- I thought, using the Access .mdb as a linked server would do the job.

- I tested this on my notebook, and it to worked fine. I used the following
sp's, the linked server worked fine:

sp_addlinkedserver 'GrpDataMDB', 'Access 2',
'Microsoft.Jet.OLEDB.4.0', 'R:\MyPath\GRPDATA.MDB'

sp_addlinkedsrvlogin 'GrpDataMDB', false, 'sa', 'Admin', NULL

- When I wanted to do the same thing on an SQL Server in the office, I got
the errormessage: "OLE DB Provider 'Microsoft.Jet.OLEDB.4.4' reported an
error. Authentication failed"

- I assume, the reason is not authentication but the fact, that on my notebook
SQLServer and .mdb where on ONE machine, in the other case they are on TWO
machines and SQL Server cannot access the .mdb across the network. This however
will cause a problem for whatever solution I can think of (a scheduled copy
evtl. could also do the job).

Have you got an idea, what I can do?