You can use the LockNavigationPane macro action in Access desktop databases to prevent users from deleting database objects that are displayed in the Navigation Pane.
Note: The LockNavigationPane macro action isn't available in Access web apps.
Setting
The LockNavigationPane macro action has the following argument.
|
Action argument |
Description |
|
Lock |
Select Yes to lock the Navigation Pane, or No to unlock the Navigation Pane. |
Remarks
Locking the Navigation Pane prevents you from deleting database objects or cutting database objects to the clipboard. It does not prevent you from performing any of the following operations:
-
Copying database objects to the clipboard
-
Pasting database objects from the clipboard
-
Displaying or hiding the Navigation Pane
-
Selecting different Navigation Pane organization schemes
-
Showing or hiding sections of the Navigation Pane
To run the LockNavigationPane action in a VBA module, use the LockNavigationPane method of the DoCmd object.
