Turn off Ribbon and hide all tables

[stryder09]

In access 2007, how do I turn off the ribbon and hide all the tables and forms so that a general user can not access them? I know how to do this in 2003 but can't find the correct menus to do this in 2007. As always any help would be appreciated.



Brad

[timmy]

you might want to split your database, this link should be helpful: http://allenbrowne.com/ser-01.html

for hiding the ribbons, insert this code behind the first form that will be loaded:

Private Sub Form_Load()
DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Sub

Also, another trick you might find useful is hiding the navigation bar:
File > Options > Current Database > Untick "Display Navigation Pane"

To temporarily show the ribbons and navigation pane, hold shift when opening the DB (this disables the autoexec)