DoCmd.LockNavigationPane

Prevent users from deleting database objects in the Navigation Pane. (Access 2007+)

Syntax
      DoCmd.LockNavigationPane(Lock)

Key
   Lock     Set to True to lock the Navigation Pane.

Locking the Navigation Pane prevents the user from deleting database objects or cutting database objects to the clipboard. It does not prevent the user 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

Example

DoCmd.LockNavigationPane True

“The only thing that helps me pass the time away; is knowing I'll be back at Echo Beach some day” ~ Martha and the Muffins

Related:

Echo - Turn screen updating on or off.