Replace an item?

I need to update an item in a database that I am searching on. How can I do this? The SQL that i have now that appears to not work is:
tmpSQL2 = "UPDATE Customers SET Customers.SalesPersonID = '99999'" & _
'''' "WHERE SalespersonID = " & tmpEmployeeID & ";"
'''' Debug.Print tmpSQL2
'''' DBTemp.Execute tmpSQL2

Hmmm...wasn't this item answered somewhere already?

Add a blank space before the word WHERE and get rid of the '''' before each line!

Cheers.

Quote of the moment....
"My job is so top secret even I don't know what I'm doing!"