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]
[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]
