A
ANDERS
Hey folks,
I have a huge VB app connection to a MS acces DB. And now cause of size
limitation i have converted i to MySQL.
Now i want to be rid of rewriting all my VB code to connect directly to
MySQL. For this i been trying to Link to the MySQL from MS access.
I have done so with some sucess. I can select data and add new rows to tables.
But when it comes to update exsisting rows i get following error:
"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time. "
I have also tried a simple exsample with one MySQL table with ID, Text
fields and a unique primary key.
Linking to that table i have same problem as before.
Im thinking this might be a driver issue or something.
But fell free to prove me otherwise, cause i am desprate need this solved
fast.
-Anders
I have a huge VB app connection to a MS acces DB. And now cause of size
limitation i have converted i to MySQL.
Now i want to be rid of rewriting all my VB code to connect directly to
MySQL. For this i been trying to Link to the MySQL from MS access.
I have done so with some sucess. I can select data and add new rows to tables.
But when it comes to update exsisting rows i get following error:
"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time. "
I have also tried a simple exsample with one MySQL table with ID, Text
fields and a unique primary key.
Linking to that table i have same problem as before.
Im thinking this might be a driver issue or something.
But fell free to prove me otherwise, cause i am desprate need this solved
fast.
-Anders