Hi all,

I hope I've not coded myself into a corner. I'm doing a visual basic 5 pro
project with mySQL as the database. Originally, I coded the prototype using
Access using a data aware bound grid control and an ordinary Data Control.

Now I have to move up to mySQL and multi-user issues. I used the ODBC Direct
mode of the Data Control because I couldnt get Remote Data Objects to work.

I've got it working fine with mySQL 4.0 except for a teensey little problem.

I can add new records just fine using the bound data grid. No problem.

I can view existing records just fine.

I cannot go back and edit them without getting a multi-user error. VB thinks
that some other user already has that existing record open and wont let me edit
it. Thats impossible because there is just one user (me) running the program.

I've read about handling multi-user issues in VB but all the examples are for
very simple controls, nothing as nastily complex as a bound data-aware grid.
All the examples also use controls in unbound mode and handle the Update method
directly in code instead of using the Data Control.

Am I stuck? Im not a good enough coder to code by hand all the stuff the Data
Control does in bound mode.

Thanks,

-John C. Network Admin.