If I say
Code:
strSQL = "UPDATE Users SET Course = " & intNewID & " WHERE Course = " & intOldID
but it does not execute correctly. It does not give me any error whatsoever but it doesn't work. What's wrong?