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 |
|
lack
Starting Member
5 Posts |
 Posted - 2009-10-06 : 21:57:13
|
| Hi guys I'm new to this forum, been around reading awhile though ;)I have an access 2000 adp which connects to SQL Server 2005. When all are set it reads all tables, views, stored procedures, and i can see them from access object browser window. tables, views are all viewable, except stored procedures..they are listed, but with ";1" suffix at the end of each names, and whenever i try to execute one it says "cannot find stored procedure"when i run the sp in management studio it runs flawlessly, i even make sure it returns only 1 recordset (access can only accept 1, btw)any ideas? is there an administration setting i need to tweak?thanks for your help in advance ^^------------- Vi Veri Universum Vivus Vici -------------* I, while living, have conquered the universe by truth * |
|
|
lack
Starting Member
5 Posts |
Posted - 2009-10-06 : 22:07:04
|
| wups, problem solved ^^it was a clean access 2000, with no service packs at all.if u have the same problem as me, do apply MS Office service pack SR-1 and then SP-3.reads well after that, and i can even ALTER PROCEDURE from access.oh, n btw, we got another machine here which is exactly the same build, clean access 2000, same "sp can't be found" problem but the forms which uses the sps runs perfectly well. MS never ceases to amaze(confuse) me XD------------- Vi Veri Universum Vivus Vici -------------* I, while living, have conquered the universe by truth * |
 |
|
|
|
|
|
|
|
Access ADP can't find Stored Procedure