I have an access front-end linked to a sql server back-end. Is there any way that I can set permissions to allow users to delete data in individual fields, but not allow them to delete an entire record? Also - another entirely unrelated question - some of my users can open multiple copies of the front-end on their computers while others can only open one. How can I change this? what causes it? I know that it may be dangerous for users to be able to open multiple copies because of record-locking - but I may want to find a way to allow it, anyway. Or, I may want to disallow it. In any case, I'd like to know how to control this feature.