Access can't greate stored procedure

P

prosconpat

Hi,
I have an ADP project which works fine in A2000 and W2K.
Two users have Win XP Pro and can't execute the stored procedures
because the stored procedures have been renamed e.g. sp_gethours to
sp_gethours;1
Can't do anything with the sp's can't open or edit etc.
I also can't create a new SP in the ADP..if I attempt to access
returns a message can't find the object storedprocedure1....
If I try the ADP on a machine with Win XP and Office XP works fine so
am missing something along the way.
Any ideas?
Many Thanks
Patrick
 
P

prosconpat

Hi,
I have an ADP project which works fine in A2000 and W2K.
Two users have Win XP Pro and can't execute the stored procedures
because the stored procedures have been renamed e.g. sp_gethours to
sp_gethours;1
Can't do anything with the sp's can't open or edit etc.
I also can't create a new SP in the ADP..if I attempt to access
returns a message can't find the object storedprocedure1....
If I try the ADP on a machine with Win XP and Office XP works fine so
am missing something along the way.
Any ideas?
Many Thanks
Patrick
Click to expand...


SR1 is the answer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Stored procedure as row source for a combo box 4
Can't create persistent ## tables with ADP call to a stored procedure(!?) 2
Accessing Stored Procedure via VBA 5
appended with a semicolon 3
Where did the Stored Procedure pane go? 4
Security 2
ADP + stored procedure + sync subform 5

Top