What's the database?

It should work on an Access db.

>Help!
>
>The following command is failing:
>
>cnPdox.Execute "INSERT INTO Method2 ([Contract #]) VALUES ('10092169');"
>
>with the message:
>
>The INSERT INTO statement contains the following unknown field name:
>'Contract #'. Make sure you have typed the name correctly and try the operation again.
>
>[Contract #] IS a valid field, a KEY field in fact. SQL sees it in an UPDATE query WHERE statement, but not in the INSERT query. Is there a problem with the # character? If I use the same INSERT command with a different field name, it works properly. What is it about the field name 'Contract #'?
>
>Thank you in advance for your time!
>John