Question Access Sql parameters Question

[ggunter]

Please forgive my ignorance. I'm from a VB6 background and new to Parameterized Queries.

I thought the PQ's were supposed to be

INSERT INTO tblAssoc ( ?, ? ) VALUES (@name, @name)

But when I try to run that I get a syntax error. If I replace the ? with the actual field name it runs. What am I not understanding?

FYI, this was being used in an INSERT query.

 

[InertiaM]

You'll need the field names.

I seem to remember that it's the values that Access has trouble with - you cant "name" the parameters, you just have to supply them in the order that they are in the PQ (I think - check this yourself)

 

[ggunter]

Got it!!

My problem was in supplying the field names at all. It should have been

INSERT INTO tblAssoc VALUES (@acid, @first, @last, @mgr, @bucket, @dept)

Not

INSERT INTO tblAssoc ( Acid, FirstName, LastName, MgrFull, Bucket, Department ) & _
VALUES (@acid, @first, @last, @mgr, @bucket, @dept)

Thanks!!