yeah from a SQL perspective, an update that affects zero rows is not an "error", but from your perspective it's a logical error, as you expected at least one row to be fiddled with. probably want to check the rows effected with @@rowcount to be sure whether your statement affected anything; are you doing that now?
show us your real code you are using; it might be something minor in your vb6 code you are overlooking, like assigning a value to a variable, or not substituting a value into your UPDATE statement.
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!