Open Error 2580

pinkandthebrain · September 10th, 2003, 11:34 AM

(Access Project frontend, SQL Server 2000 backend)
I have come across error 2580 when trying to open a report bound to a stored procedure. I've noticed that the stored procedures that are run through code work fine but those bound to reports caused problems.
Anyone with administrative access does not run into this problem. I've tried Running the Stored Procedure from within Access and it works, just doesn't seem to find it in Reports and Forms, unless run from code. Any help would be appreciated

rgerald · September 10th, 2003, 12:23 PM

I use Access (.mdb) along with SQL Server stored procedures. In order for Access to see the sp I have to use a pass through query. This may not be necessary with an Access Data Project but it's worth a try.

The pass-through query works as follows:

Code:

EXEC {the name of the sp} {parameter1}, {parameter2}, etc.

Code:

EXEC usp_MyStoredProcedure 'John', 'Smith', 'Chicago'

This assumes your parameters are FirstName, LastName and City.

The pass-through query MUST be specifically pointed to the correct Server and Database with the connect string.

ODBC Connect String:

Code:

ODBC;DRIVER={SQL Server};SERVER=TheNameOfYourServer;Database=TheNameOfYourSQLDatabase;Trusted_Connection= Yes

Rand

pinkandthebrain · September 10th, 2003, 02:06 PM

Why would it then work for Administrators without using a passthru query? It only happens with users set as dbo.

pinkandthebrain · September 15th, 2003, 11:16 AM

Found what I was looking for at this link:
http://support.microsoft.com:80/supp...NoWebContent=1
(Administrators had the patch installed)