How do i handle concurrent update,modifications,additions on a multi user system using ADO with Microsoft Access 97 database. Also suggest me some solution if possible by which i can know the status of the records if other users are currently modifying/adding/deleting a record, using ADO without firing any additional queries on the database with some ADO flags?