How does access disable display window modification of Background Data?

1. query lock records. Right-click to query the design interface properties, and click Properties-record lock. We will find three situations. 1. Do not lock: The queried data is not locked and can be deleted or changed. 2. All records are locked. Prohibit the modification or deletion of data when the form is called. However, odbc cannot lock all records; 3. Edited

1. query lock records. Right-click to query the design interface properties, and click Properties-record lock. We will find three situations. 1. Do not lock: The queried data is not locked and can be deleted or changed. 2. All records are locked. Prohibit the modification or deletion of data when the form is called. However, odbc cannot lock all records; 3. Edited

1. query lock records.

Right-click to query the design interface properties, and click Properties-record lock. We will find three situations.

1. Do not lock: The queried data is not locked and can be deleted or changed;

2. All records: Lock the queried data. Prohibit the modification or deletion of data when the form is called. However, odbc cannot lock all records;

3. Edited records: Lock the edited records. However, the unedited records are not locked.

The above locked records are not affected when the data query is opened in the background, but some modification operations are prohibited when the query is called in the form.

Ii. subform locking.

The subform displays the query data, and its lock is consistent with the query lock record. Users cannot modify and query data at will. Of course, sub-forms also provide many function attributes for operation.

For example, attributes can be edited, deleted, or added, and are set differently based on different users.

3. display the locked main form.

In the final design for users, we usually start it in the menu. Retained the following by default.

The allowed toolbar/menu in the shortcut menu bar is equivalent to the shortcut menu. If checked, the system displays changes, additions, and other functions.

Operate by graph to ensure that the form is locked.