can someone help me on passing parameters to stored procedures in MSAccess using VB6?
for example, i have a stored procedure named "Addrec", which functions for inputting data. if i have parameters: name, address and email.. how can i do it in vb6 code using ADODB.. here are my incomplete sample of codes:
dim cnxn as new ADODB.connection
dim cmd as new ADODB.command
cnxn= (* connection string to database...... *)
cnxn.open
set cmd.ActiveConnection=cnxn
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "Addrec"
'-----------------------------------------------------
* passing of parameters could be right here *
'---------------------------------------------------
cmd.Execute
--- thanks a lot!!!! ;p
