SQL Server procedure kills my VB (sometimes)

I have an application which is a SQL Server 7 back end with VB 6 SP5 front end.

For some of my users, when the VB code calls a particular stored procedure, it causes VB to die without executing the stored procedure. I am connecting via ADO.


If I execute the same stored procedure via Query Analyzer on the same machines it works perfectly.

The same code also works perfectly on all the development machines.

The error only occurs for a particular stored procedure. Other stored procedures execute perfectly on the users' machines.

Any ideas?????