HI
as per the description of your job post, is 3197 error in access, well it all depends on how you are accessing your database. You are using some application to use your database DB or directly updating the records. Its all because of the recordset getting locked and records not to be updated from two places at a time.
Hope your query will be result by the description above. If not you can get in touch with me to get it resolved.
thanks