All,
I have a sync problem between VB.NET and a MS Access database.

I have an unbounded datagrid which shows the content of a table.

When I want to delete a record from the Database, I select the row in the grid, which has also the ID of the record, and I perform a command like
"Delete from mytable where ID = selected_id"

After this sql command, I perform a a "SELECT * from mytable" statement, to show the changes in the datagrid.

The problem is that between the Delete and the Select statements, the code runs so fast that the Select still gets the previous content of the table, so the record which has been just 'deleted', still appears in the datagrid.

If I re-load after a second the datagrid, then it reflects the changes.

Question: is there any way to know when the table has been effectively updated ?

I have tryed also using transaction (begin and commit), but no luck. The problem arises when in the table there are at least 15-20 records or more. When the table contains less records, then it is 'fast enough', and this issue does not arise.

Any help would be greately appreciated.

Sergio.