Re: tweak of A2002 Enterprise Dev Handbook fails?

Thanks Bob,

I removed the Parameters declaration and just created them in the
query itself (I thought ADO couldn't access the parameters collection
of what I thought was a DAO object... shows what I know!). but when I
took that out, it worked a champ!

thanks!

Pieter

Here's the part of the code I changed...

Set cmd.ActiveConnection = cnn
cmd.CommandText = "xp_ActiveSkills"
cmd.CommandType = adCmdStoredProc

' Execute the command and place results
' in Recordset object.
Set rst = New ADODB.Recordset
cnn.xp_ActiveSkills intBuildDay, rst


.