Hi,

I am using datagrid and adodc controls in visual Basic. Adodc is connected to Access database, and the datasource of the datagrid is adodc. I am wondering when I make changes to the datagrid, is it immediately seen in Access database, and vice versa? The reason I am asking this question is that I did run into some strange behaviour: 1. when I update sth in Access, the corresponding datagrid entry is not immediately changed even after requerying adodc and rebinding datagrid.
2. When I make changes to the datagrid, those changes seems not immediately reflective in Acess.

I would appreciate any suggestion.

Cindy

try this code for refreshing

sub refreshgrid()
  On Error GoTo RefreshErr
  Set grdDataGrid.DataSource = Nothing
  adoPrimaryRS.Requery
  Set grdDataGrid.DataSource = adoPrimaryRS

  Exit Sub
RefreshErr:
  MsgBox Err.Description
end sub

Ahmed Ali
Software Developer