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