Passing a Parameter to Linked Server (MS Access)

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Passing a Parameter to Linked Server (MS Access)

Author

Topic

Windza
Yak Posting Veteran

61 Posts

Posted - 2010-05-25 : 23:30:53

Hi All,

I have a MS Access DB configured as a linked server and wish to pass a parameter from SQL to initiate a query stored in the DB.

e.g.
Access DB (AccDB)has the following query stored locally as ExampleQuery:

SELECT *
FROM Example
WHERE Example.Parameter = @Parameter

From SQL I want to call ExampleQuery with a value assigned to @Parameter... this is what I've tried but with no luck:

DECLARE @Parameter varchar(10)
SET @Parameter = 'Parameter'
SELECT *
FROM AccDB...ExampleQuery

The access query does not detect the @Parameter value... what do I need to do?

Cheers,

agrajtech11
Starting Member

2 Posts

Posted - 2010-05-26 : 07:51:35

It is tough to pass parameter in a query but it makes easy and small the software. I also wants to learn it so please help me by providing these codes and for performing other tasks in SQL Server.

(Link Removed)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources