MySQL Forums
Forum List  »  Microsoft Access

Re: linked table is not updateable
Posted by: Claudio Domiziani
Date: March 14, 2005 10:42AM

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

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 :,6094,18251#msg-18251

Let me know if this solved your issue !


Options: ReplyQuote

Written By
March 12, 2005 06:40PM
March 14, 2005 08:47AM
Re: linked table is not updateable
March 14, 2005 10:42AM
March 16, 2005 03:18PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.