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.
| Author |
Topic |
|
ingineu
Yak Posting Veteran
89 Posts |
 Posted - 2003-09-10 : 12:04:13
|
| 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. |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-09-11 : 03:59:14
|
| Write in Procedure Name (as Data Source) manually and withprocedure owner name prefix e.g. >> dbo.myProcAccess still rebuffs on that yet it will work. |
 |
|
|
ingineu
Yak Posting Veteran
89 Posts |
Posted - 2003-09-11 : 17:44:13
|
| Thanks so much .. that worked for 1 user, but not for another. I noticed that this user has ';1 (dbo)' tacked onto the end of the Stored Procedures when I look at the Access Stored Procedures. Any idea where the ;1 comes from? (By the way .. I had my original question on some other forums for some time with no answer, even found the same question on another forum some time ago with no response .. you're the first to answer!) |
|
|
|
ingineu
Yak Posting Veteran
89 Posts |
Posted - 2003-09-11 : 21:44:51
|
| Found what I was looking for at this link:http://support.microsoft.com:80/support/kb/articles/Q269/8/24.asp&NoWebContent=1 |
|
|
|
|
|
|
Open Error 2580