Remove Quick Access Toolbar

[sjarvis]

Hi, i am not technical but have written an access 2003 database. Some of my users have gone onto 2007 and i have a couple of security issues. In 2003 i could hide the forms, tables etc on start up but in 2007 you can still right click on the access button and the quick access toolbar comes up which will allow them to go in and unhide etc should they wish to. This is a nightmare as i don't want to give then the option to copy tables etc. i have seen people suggest to put in the code DoCmd.ShowToolbar "Ribbon", acToolbarNo
but where does this go as i have not written the database in VBE. Also i would like to hide the ribbon as long as the users can filter etc, i do not want then to be able to delete records. i can move to 2007 if this is easier.

 

[Trevor G]

Hi, i am not technical but have written an access 2003 database. Some of my users have gone onto 2007 and i have a couple of security issues. In 2003 i could hide the forms, tables etc on start up but in 2007 you can still right click on the access button and the quick access toolbar comes up which will allow them to go in and unhide etc should they wish to. This is a nightmare as i don't want to give then the option to copy tables etc. i have seen people suggest to put in the code DoCmd.ShowToolbar "Ribbon", acToolbarNo
but where does this go as i have not written the database in VBE. Also i would like to hide the ribbon as long as the users can filter etc, i do not want then to be able to delete records. i can move to 2007 if this is easier.

Welcome to the Forum,

If you have a form that is loaded first then you can add your code to the On Open Event of that form which should then hide the Ribbon.

Open the form in design view and then open the properties then go to the Events Tab, search down the list until you find open

Private Sub Form_Open(Cancel As Integer)
DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Sub

You could also consider placing a message box when the user trys using the right mouse button so you can eleminate the menu there or place in your own so they don't get access to design view etc.

You could also consider splitting the database so the users only deal with the forms.

As regards not allowing deleting records, if the tables are related you could stop the relationship from using the cascade Delete option, which helps prevent deleting.