I have an Access front end. The back end are sql server tables. Does this mess up the way Access locks records? for example, when i set both the form and database to lock edited records, i can still edit a record on computer 2 after i've changed but not saved the same record from computer 1.