SQL Update error using Autonumber 1

[ukwebsite]

Please help

Im trying to update an Access database using the following script

UPDATE items SET image = 'none' WHERE id = '1'

image is of type Text id is of type Autonumber.

I get the message

Data type mismatch in criteria expression. X-)

I even get this message using the SQL query thing in Access. If I change the ID to text instead of Autonumber it works fine.

Please help
Matthew Wilde
matthew@ukwebsite.com

 

[froggerIII]

get rid of the single quotes around 1

UPDATE items SET image = 'none' WHERE id = 1 ray
rheindl@bju.edu

 

[ukwebsite]

Cheers works perfectly.

Thanks a lot
Matthew Wilde
matthew@ukwebsite.com