I have 2013 access db split with shared BackEnd on server, and FrontEnds for multiple users local PC. The endusers are not "database" savy and need several split forms to help work with the data we have (where the forms show a single record and the complete table of records in the same form). All the frontends have direct links to the tables in the BE (there are no local tables used in the FE) What I've been concerned about is how to manage a user editing the a record in a table at the same time that table is being used by others. I need that specific record "locked" down from others until the edits are done. I dont know what kind of options I can use for Access 2013 to lock a record or table when a record is being updated. The edits work directly on the form or table so I'm not using recordsets to manage lockouts that way. Most of the controls listed online deals with old MDB versions. Can anyone help on this with Access 2013??? Thanks