about execute storeprocedure with parameter

[kcobain]

hello:

How can I run(or call) a sqlserver storeprocedure with parameter from Access
vba,

for example, i have a storeprocedure like :

create procedure xxxtest @loginacco nvarchar(10)
as
insert into xxxtable (loginacco) value (@loginacco)


usually i can call storeprocedure like docmd.openstoreprocedure
"dbo.xxxprocedure",
but how should i execute storeprocedure with parameter?

thanks for any help