Refresh of data Grid

[ching0418]

in my program, i previously worked with SQL Server database and i had no problem...bu when i shift to MS access database, i'm having problem with refreshing the data grid, it doesn't automatically update...when i do something, the data grid doesn;t change...when i do my second update, the grid is updated but reflects the previous change that i did not the latest...

what might have caused this, and what can i do to refresh the grid immediately...

TIA,
ching

 

[perplexd]

This may be to do with update lags. Although you tell MSAccess to update, this is not necessarily done instantly, although it will inform your computer that it has been done.

Maybe you could only update to the database once all the changes are made, but display the changes that have been made on the user's PC? It all depends on what you are aiming to do though...