Anyway to disable Quick Access Toolbar in Access 2010 with code?

[LittleNick]

Good Morning,

Is there a way to disable Quick Access Toolbar so that users can not add commands that allow them to access the design of forms/reports or data (delete)?

Thank you.

 

[1DMF]

Are you rolling out copies of the ACCDB as your application?

Try using ACCDE or better still ACCDR with the runtime.

Saves money on needing Office with Access for every user and also locks the application down to a user runnable version only.

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music

 

[drochel]

Here are examples of how I am hiding and unhiding the navigational bar and ribbon.

Function SecureProperties()
' Hide Navigation Panel
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide

' Hide Ribbon
DoCmd.ShowToolbar "Ribbon", acToolbarNo

End Function

Function UnSecureProperties()
' Show Navigation Panel
DoCmd.SelectObject acTable, , True

' Show Ribbon
DoCmd.ShowToolbar "Ribbon", acToolbarYes

End Function