DataGrid Updates

Ok I am new to DB programming. I am using ADO with a connection to an Access 2000 MDB. Everything is going fine except the Data Grid when two people change the same value before the values get refreshed. Here is the message I get:

“The specified row could not be located for updating: Some values may have been changed since it was last read.”

Now I can deal with record errors and updates in other areas with data bound fields but I can’t seam to nail the Data Grid down.

Any help would be appreciated.
Thanks

If you're using DBGrid control then use it's error event to catch the error.