SQL server SP from Access 2000

[glealv]

Hi, I am wondering why this SP does not return any rows when executed from Access 2000?
[CREATE PROCEDURE [dbo].[UspContaks] @clyent nvarchar(7) AS
select *
from tabContacts
where ClientID = @clyent
order by ClientID, ContactKey
GO]

Access 2000 VBA:
[conLocal.Open "Provider=SQLOLEDB;Server=HXXPFSRV08;Database=CustService;Trusted_Connection=Yes"
conLocal.Execute "UspContaks 'Y338032'", lngRows]

 

[Jokada]

i suppose you work in an ADP
you can easy execute Sp with this code

lstGeraete.RowSource = "EXEC SP_geraeteFilter '" & cboGraeteWahl.Value & "'"
' the text behind the Sp name are parameters
or to make it avaailable to the form (just enter the field name in the bound field)
use:
Form.RecordSource = "EXEC SP_EditLieferant " & iLieferantIDTemp

i suggest when using SP to return values that you make a select statement with all fieldnames insead of the "*"