Update, Updates all records rather than just a single record

[Dan]

I ve developed some front page .asp forms to record, retrieve and update
records in an Access D/B.
The update form uses the following SQL Statement to update the address
field. Everything works, no errors, but it seems that even though the SQL
statement says update where id=id, that all records in the d/b are getting
updated.
UPDATE Results
SET Address='::Address::'
WHERE (ID=ID)
So if I retrieve record 1 and change the address, when I go back and look at
all the records the address for all records have been changed to the value I
entered for record 1! Hm?

Any hints?
Any help is appreciated.

Dan