MYSQL Problem - Delete user

hi, i have a problem here, i after i use the command below :-

"DELETE FROM mysql.user WHERE user ='" & User_ID & "'"


The user in the [user table] is deleted, but when i log in to mysql again, that user name and password still can log in. can i know why this kind of problem can happen.


another problem again, when i update the password in user table, after i log in to mysql again, i found that the new password and old password also can access. i really don't know why this kind of this is going to happen.

i hope i can get a solution as soon as possible, thank you.

Regards, James

I don't reaally use SQL Server that often but look into...

Are you using a local cache (dataset)? make sure you are not just updating here.

Are you issuing a commit to the db? Sounds like the changes are sitting in transactional state

Cheers...