Newbie Urgent Question on connecting from SQL Server Express 2005 to MS Access
Posted on 2006-07-01
Basic but urgent question... I've got SQL Server Express locally on my workstation. I also have an MS Acces database locally on my workstation. From SQL Server, I must run a series of SELECT statements against the Access database. I understand from the docs and online that I need to have a linked server. Apparently, I'm not getting the syntax right, however.
The MS Access DB has no security. The workstation user is 'Tom.'
The error I get on the 2nd statement below is:
Msg 15007, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 76
'Tom' is not a valid login or you do not have permission.
@server = 'pcf'
, @Srvproduct = 'Access'
, @Provider = 'Microsoft.Jet.OLEDB.4.0'
, @datasrc = 'C:\mydata\Tom01JUL.mdb'
sp_addlinkedsrvlogin 'pcf', false, 'Tom', 'Admin', NULL;
Though not difficult, there's a level of urgency on this, so thus the higher point ranking.