>I have a stored procedure in SQL Server 2005 Express. It includes a
> distributed query that pulls from a table in a local SQL Server
> database, and combines this with some data in a remote Access
> database. I have that Access db referenced in SQL Server Express as a
> linked server, and have had no trouble querying against it from with
> SQL Server Mgmt Studio.
>
> However, when calling the sp from within VB Express, the server always
> returns an error that the linked server could not be found and I need
> to run sp_addlinkedserver (which I've already done) to register it.
>
> Is this a security issue, or a restriction of using the Express
> editions of SQL Server and/or VB 2005, or something else. I've tried
> executing the sp in code and through the IDE. Neither works.
>
> Thanks,
> Daniel
>