ARRGH!! This UPDATE statement:

cnn1.Execute "UPDATE UserID SET UserName = Null WHERE UserNumber = " & UserNum, , adExecuteNoRecords

WON'T work(ie it DOES NOT change the UserName field to Null). I've got the field setup as a text field in the A2K table(UserID with only 2 fields: UserNumber(Primary Key) and UserName). Does ANYONE have a clue as to WHY this won't work?? Thanks for ANY help!