Hi All,

Can anyone see what is wrong with this Query for an Access 2000 database? It's probably staring me in the face but I just can't see it.

UPDATE NSProposals SET Status='D', NSReason='NA', CoverNote='NA' WHERE ProposalNumber='NS03/000001'

This is the error message I get:

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

I have checked that all the datanames are correct (I even cut & pasted them from the table definition), all the fields are text type,
and the cursor type is dynamic.

I'm totally stumped.

Thanks
Pat

-------------------
System 3 2000 Limited
www.system3-2000.co.uk

__________________
-------------------
System 3 2000 Limited
www.system3-2000.co.uk (but very out-of-date!)

Generaly it seems that u assigned (or set) unexpected data type to some variable.
Can u provide more code details?

...but the Soon is eclipsed by the Moon