Forms based on stored procedures - not opening

[slames]

I have moved this post into this forum, hoping it is more appropriate
Hi, I hope someone here will be able to shed some light on a problem I'm having. When I try to open a form (Access 2000 front end)based on a stored procedure (SQL server 2000), it errors and closes, and when I want to go to the design view of a stored procedure nothing shows.
I think the problem is related to the fact that all stored procedures when viewed in the database window are followed by ;1 I have seen this before somewhere but just can't remember what the problem was. I've searched everywhere for an answer but can't find one.

Can anyone please please help as we can't use our database at the moment.

Thanks in advance

 

[slames]

Just to add to the picture:
Ok, thanks for your reply. I have other copies of this database working perfectly on other computers but the stored procedures do not have the ;1 after their names.

When I look at the version that is not working properly and try to go in to design view of the stored procedures it says it is unable to locate it - probably because of the ;1.

If this is an optional parameter how do I remove it as it won't let me rename because it can't find it?

This is really bugging me so if anyone can shed any light on this situation that would be great.

Thanks

Steph