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 |
|
Mathias
Posting Yak Master
119 Posts |
 Posted - 2002-05-14 : 02:59:35
|
| I am using : NT4,SP6personal SQL 2000, SP2ADO 2.6Whithin Access ADP project, I can select some procedure without problem, for some others I have the error message : Microsoft Access can't find the object 'Microsoft Access can't find the object 'myprocedure'.'The report is also refering to input parameters.When I run the report, it is working fine. I could work like that but in ADE, I am stuck with the error.I ahve been looking this issue for 3 weeks now.I tried also to live the recordsource blank and move the value on the on_open event. If this is done, the input parameters are not considered. I tried to eliminate the inputparameters and move them within the recordsource statement but it doesn't work either. |
|
|
kaus
Posting Yak Master
179 Posts |
Posted - 2002-05-14 : 19:51:47
|
| You might check that the stored procedure with the error is owned by the user that you are connected as, or have permissions for that stored procedure. I was having some problems with tables where this was an issuePete |
 |
|
|
Mathias
Posting Yak Master
119 Posts |
Posted - 2002-05-16 : 02:30:14
|
| I have found the root cause of the problem :users did not have access to the sysobjects on the SQL server. After having added the select right and added dbo. in front of the functions or procedures that were causing problems, the problem desapear.Paul |
|
|
|
|
|
|
Microsoft Access can't find the object : store pr