My Access database is "split" so that tables are in one file on the network, and there is copy of application at each user's computer, which is linked to these tables.
I have the various forms in the application set to "edited record" locking, so that only one person at a time can edit a record. The problem is, my main form has a subform on it. It appears that while one person is editing (or deleting?) the main record, somebody can be editing records on the sub-form.
So my question is...is there a way to simultaneously lock all subforms/records belonging to a main form/record?
I have the various forms in the application set to "edited record" locking, so that only one person at a time can edit a record. The problem is, my main form has a subform on it. It appears that while one person is editing (or deleting?) the main record, somebody can be editing records on the sub-form.
So my question is...is there a way to simultaneously lock all subforms/records belonging to a main form/record?
