MySQL and VB6, reading/writing

Hi, i wish to read from my database and write to it at the same time. However when i do this in my code it doesnt let me unless i close the original read query when i am performing the write.

Is there anyway that i can read from a table and write to it, without having to close the original read query?

Thanks in advance :)

amanda6192,

Without seeing how you are obtaining records this is a guess. You are probably locking the records when you get them to look at them.