May 9, 2006 at 7:07 am
I am trying to create and use a linked server to an Access db through adodb. I can create the server OK but when I try and execute a query through code I get an error saying the workgroup file is missing or someone else is using the database. The strange thing is that if I run the query through the query analyser installed on the server it works.
I have tried copying the system.mdw file to places such as the windows folder but to no avail I have tried specifying the path to the mdw file in the provider string of the linked server but this prevents me from accessing the linked server. I think perhaps my provider string is wrong? I also wonder why I need to specify the mdw file through the code when I don't through Ent Manager.
Thanks
Andrew
May 10, 2006 at 4:20 am
All,
I have now solved this by using this t-sql command.
EXEC sp_addlinkedsrvlogin 'Servername', 'false', NULL, 'Admin', NULL"
If anyone has a similar problem and wants more details please ask.
Thank you
Andrew
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply