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.

 All Forums
 Other Forums
 MS Access
 Problem with stored procedure on some computer

Author  Topic 

will91
Starting Member

6 Posts

Posted - 2003-11-06 : 13:40:56
On some of the computer the name of my stored proc change in my access project, it add ";1" or ";0" and it's impossible to execute those, it say that it's impossible to find the stored procedure 'dbo.the_name;1'. What can I do?

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2003-11-07 : 11:12:10
Sounds Like your crossing over from a old version of access to a new and the S.P. contains code the new version will not tollerate.

I had this happen a few times.

one of the most common problems I found was " " around literal text instead of ' '.

Remenber the SP is SQL not VB.

Jim
Users <> Logic
Go to Top of Page
   

- Advertisement -