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:
“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
Echo - Turn screen updating on or off.