JOINed table are almost always read only. One of the workaround to this is to send direct queries (update) to the database and refresh the recordset.
>I have to tables that are related with one field
>
>So i make join with the two tables and bind the resulting cursor to the datagrid, my problem is that if I try to change the value of a field in the grid and update, i get an error.
>
>Is there a way to solve this problem.
>
>The database i use is Access, and if you do that in access it works fine, why in the datagrid doesn't?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com