I have set up the linked server OK but it is failing to connect properly.
Anyone know what I need to do to fix this?
I have also posted this in sqlserver.programming where someone suggested I
post it in an Access newsgroup. This one seemed most likely.
Scripts and precise error message below.
EXEC sp_addlinkedserver
@[EMAIL PROTECTED]
= N'MyAccessDB',
@[EMAIL PROTECTED]
= N'Microsoft.Jet.OLEDB.4.0',
@[EMAIL PROTECTED]
= N'Access',
@[EMAIL PROTECTED]
= N'\\mynetwork\dfs\CallCentre\Germany\Departments\Hotline\'
GO
-- Runs OK
-- Set up login mapping
EXEC sp_addlinkedsrvlogin
@[EMAIL PROTECTED]
= N'MyAccessDB',
@[EMAIL PROTECTED]
= N'false',
@[EMAIL PROTECTED]
= NULL,
@[EMAIL PROTECTED]
= N'operations',
@[EMAIL PROTECTED]
= 'MyAccess'
GO
-- Runs OK
-- List the tables on the linked server
EXEC sp_tables_ex N'MyAccessDB'
GO
-- Gives message
--OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "MyAccessDB"
returned message "Cannot start your application. The workgroup information
file is missing or opened exclusively by another user.".
--Msg 7399, Level 16, State 1, Procedure sp_tables_ex, Line 41
--The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server
"MyAccessDB" re****ted an error. Authentication failed.
--Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41
--Cannot initialize the data source object of OLE DB provider
"Microsoft.Jet.OLEDB.4.0" for linked server "MyAccessDB".
Notes: The access db is definately not opened exclusively by another user
as
I
can open it OK via Access itself using the same credentials.
TIA
Nigel Ainscoe
|
