Does anyone have the code for refreshing a OleDB .mdb database?

[piscis]

How to “REFRESH” a database.

Does anyone have the code for refreshing a OleDB .mdb database?

On a Tabcontrol, Tab1 page I insert a record into a Datagrid.1 and click update using dataAdapter1-dataSet1 combination. No problem here.

On the Tab2 page I have the same database connection but with a Parent-Child relationship showing a few textboxes and a Datagrid.2 with dataAdapter2-dataSet2.

The problems comes with the Record that was inserted in Tab1 not being shown in Datagrid.2 in Tab2.

When I quit the application and started it again the Record is indeed shown in Datagrid.2 in Tab2.

What should I do to refresh Datagrid.2 so the records inserted in Tab1 appears immediately.

I tried these but none of the code below works.
Me. Datagrid.2_PositionChanged()
Datagrid.2.Refresh()

Andy

[Pirate]

Reconnect again to your database , I've done the same with no problems.