<b>What are the error messages ?
<i>Providing more information will for sure lead to more useful responses</i>.</b>
From the code you pasted, I would check the following:
– You are using quotes for all of the values to update and the comparisons in the where clause. Make sure this is valid when comparing to some data types such as dates or numbers. You could have type mismatch errors.
– It seems that a space is needed before the WHERE keyword. This could work in some databases, but I’m not sure if it will work on access.