Call INS/UPD Query (PARAMS) From VB

[svagelis]

I m calling from VB6 and through ADO's Command Object an update query which IS LOCATED in an Access database and it updates one table.
This query accepts 12 parameters(Declared in query).
Well i create those parameters from Command object but when i execute the command it says 'too few parameters expected 13'

I m thinging it might want me to add a return code parameter (Like SQL Server)
objcmd.Parameters.Append _
objcmd.CreateParameter("RC", adInteger, adParamReturnValue)

but i doesnt recognize the RC parameter...
Any Solution to my problem ??
Thanks in advance

 

[Nowell]

Hi

Ok I'm not really very clued up about this, but I had a problem with using double quotes and to resolve the problem I used single quotes.
Just a thought, hope it helps

 

[svagelis]

thats ok. I ve found it. I was doing something wrong within my query.
It works fine now.Thanks anyway.