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-07-11 : 03:28:31
|
| I'm working on a report that pops up with this error when I try to set the Record source:'Microsoft Access can't find the object ..'The STORED PROCEDURE appears in the drop down list and upon selecting it, the message appears. The SPROC also shows up in Access under Stored Procedures, although when I run it from that platform, it returns 0 records whereas in SQL Server records are returned. The only difference I can see is that this procedure contains a number of SELECT statements with INSERT and a #work reference. Do I need to compile the procedure?Thanks. |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-07-11 : 04:09:54
|
| Add into your SP body (as first line):set nocount on- Vit |
 |
|
|
ingineu
Yak Posting Veteran
89 Posts |
Posted - 2003-07-11 : 11:23:06
|
| I still get the same message in the Access Report. I noticed however that the stored procedure now returns the records. I can select any procedure from the list for Report FORM Row Source except for procedures, it seems with references to temporary tables. |
|
|
|
ingineu
Yak Posting Veteran
89 Posts |
Posted - 2003-07-12 : 21:25:03
|
| It now works. I cleared the Input Parameter property and reentered the values and recompiled. The error message still appears, most likely always will. |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-07-14 : 02:32:37
|
| I had a try on it. Indeed, a bit buggish like.- Vit |
|
|
|
|
|
|
Microsoft Access can't find the object .. message