Linked Server ERROR

[Jesus4u]

This is a stressfull problem.

Scenario:
Win2K Server with SQL2000 server on same box.

I get an error that says:

The code below is using linked server to SELECT from an Access 2003 database.

		SELECT null as StoryID, TITLE as Headline, AIRDATE AS pubDate, [DESC] AS [Intro], '[URL unfurl="true"]http://www.coralridgehour.org'[/URL] as NewsLink FROM [COLOR=red yellow]CRM_MDB...BROADCASTS[/color]
		WHERE PROG ='CRH' AND
			(CONVERT(CHAR(10),AIRDATE,101) = CONVERT(CHAR(10),@SBEGINSUNDAY,101)
			OR
			CONVERT(CHAR(10),AIRDATE,101) = CONVERT(CHAR(10),@SBEGINSUNDAY-7,101)
			OR
			CONVERT(CHAR(10),AIRDATE,101) = CONVERT(CHAR(10),@SBEGINSUNDAY-14,101))
		ORDER BY AIRDATE DESC

Can anyone please help me out?

Exams Passed: 70-152, 70-175, 70-176, 70-100

 

[JayKusch]

I do not beleive you have the appropriate right on the Access DB you are hitting.

Thanks

J. Kusch

 

[Jesus4u]

yes I realize that. I have to abandon this idea now due to work time constraints. Thanks anyway....

Exams Passed: 70-152, 70-175, 70-176, 70-100