What is WRONG with this UPDATE statement?

[Thom]

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!

[Thom]

I'm getting "Run-Time Error 2147467259, Operation must use an updateable query"??? What the #(*$)# does THAT mean? I've Never seen that error before-could there be something messed up in the A2K database I'm using? Please help!!

[kleagle]

Try

cnn1.execute("Update A2K SET UserName = null WHERE UserNumber = " & UserNum")

Hope it helps.

Regards.

KT

[Thom]

THanks! That was CLOSE to what was wrong, appreciate it!