How to post Datagrid back to access table

[New_Coder]

2 Questins How do I update my access table with changes from 1 field only? Is there an easy way to post the whole datagrid to an access table or do I need to loop through every row in the datagrid table.

[noshaba mariam]

to update ur table with one field u can do as follows: dim con as new adodb.connection dim rs as new adodb.recordset con.open connection_string rs.open "Select * from table1 where field1 = '100'" , con if rs.eof = false then rs.movefirst rs.fields("field1") = txt1.text rs.update else msgbox "record not found" end if