RE: MySQL/ Access newbie problem: Access DB not editable - please help

>> [JS] Are you using ODBC so that Access can update a MySQL database?
>
>Yes, exactly.
<snip>
>
>I'm not sure if I completely understand you but it was by opening one of
>the
>linked tables that I discovered that I couldn't amend data in the table
>but I
>could add new entries.
>
[JS] Well, that is certainly a major clue! Anything you can do in datasheet 
view, you should be able to do with a query, so that's an easy way to test.

I think you have a permissions problem for this user. INSERT permission does 
not grant UPDATE permission.

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com



>Thanks
>
>Ian





-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]