Hi Don,
Would you please post the following information?
1. What is the stored procedure? If you run a simple another stored
procedure, does it work?
2. I assume the problem is:
a. Access 2000 adp client (run time or full version installed on the
clients) connects to SQL 7.0, it works fine.
b. Change Access 2000 adp/ade to connect SQL 2000, no other things changed,
it doesn't work. What happens? Do you receive any error message?
3. When you run a trace on SQL Server side, you find the stored procedures
execute with "select * from "spxxx"" when adp connects to SQL 2000 (failed
one); However, when adp connects to SQL 7.0, it executes with "Exec
"spxxx"" (successful one). Right?
I look forward to hearing from you.
Sincerely,
Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <
www.microsoft.com/security>
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Don Fowler" <
[email protected]>
|
| I have the same permissions on the tables, sp's etc. It
| is a restored backup of the original. I also have tried
| installing Access from Office XP. When the client uses
| that, it also works. I get a "Exec "spxxx"" in the
| trace. It seems to be the version of the run time. All
| the clients do not have Office pro, so I need to use a
| runtime on them. Any help?
| >-----Original Message-----
| >I usually get this when the login does not have
| permission to execute the
| >Stored procedure.
| >
| >| >> I have an Access app that uses SQL 7. When I changed
| the
| >> ade to connect to SQL 2000, the stored procedures don't
| >> work. When I run a trace on SQL, the stored procedures
| >> execute with "select * from "spxxx"". With the
| runtime I
| >> have developed ( in Access 2000) the sp's for SQL 7 run
| >> with "Exec "spxxx"". Why the difference?
| >
| >
| >.
| >
|