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
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

Options: ReplyQuote


Subject
Views
Written By
Posted
5706
March 12, 2005 06:40PM
2416
March 14, 2005 08:47AM
Re: linked table is not updateable
3035
March 14, 2005 10:42AM
2272
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.