On Thu, 01 Nov 2001 11:03:56 -0800, Alan Hogue wrote: >I am trying to execute an update to an Access database. The statement >has two placeholders, and I put two variables between the parentheses in >the execute statement, and yet Access tells me it expects 3 parameters.
This behaviour has had me baffled for a long while, too. It is typical, as I've mentioned here before, for when you mistyped a field name. It looks as if Access thinks of unknown field names as parameters, as it does when you run such a query in Access. -- Bart.