Check permissions (grants) for user that login to mysql server (i.e. user in the authentication form when you create a DSN from ODBC datasources).
mysql> SHOW GRANTS FOR '{user}'@'%';
example :
//------------------------- CUT
mysql> SHOW GRANTS FOR 'root'@'%';
+-------------------------------------------------------------------------------------+
| Grants for root@% |
+-------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '40313c1258550e59' |
+-------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
//----------------------------- CUT
mysql>
it must seem like this. if not, you don't have privileges to update table. See Mysql manual for setting grants to users (the % sign represents any host. In your case it can be your IP address from which you connect to the server).
If no work,
If you are running Mysql > 4.0 try to use MyODBC3.51.11-2
if you are running Mysql 3.23.x, try to use MyODBC3.51.9
If no work , try to check points I wrote here :
http://forums.mysql.com/read.php?65,6094,18251#msg-18251
Let me know if this solved your issue !
Regards,
Claudio