If I saybut it does not execute correctly. It does not give me any error whatsoever but it doesn't work. What's wrong?Code:strSQL = "UPDATE Users SET Course = " & intNewID & " WHERE Course = " & intOldID
Printable View
If I saybut it does not execute correctly. It does not give me any error whatsoever but it doesn't work. What's wrong?Code:strSQL = "UPDATE Users SET Course = " & intNewID & " WHERE Course = " & intOldID
This may seem a silly question but the Course field is not a key field is it.
When you say it does not work does nothing at all happen or does something unexpected happen.
It would be helpful if you post the error text as well..
Hey did you executed the stated in the ADO connection
aniz
Sorry, I read your post wrong..
Post the code you are using to execute the query.
Let me put it this way.
When you do execute the command what exactly does happen and can you post some extra code to demonstrate how and when the code is being executed.