PDA

View Full Version : Keeping casual users out of the navigation pane



DBinPhilly
01-14-2018, 10:08 PM
How can I turn off access to the navigation pane without using runtime?
One of my users has chanced his way into the database programming and I want to turn off that ability.

ranman256
01-15-2018, 10:26 AM
youd 'SAVE AS' the database into an .ACCDE
then they cannot get into the code.
also
hide the db.

I use this as the 1st statement in the autoexec macro: RunCode HideDB()
so users cannot see the tables/queries/etc.
The 2nd statement is OpenForm MainMenu



Public Function HideDB()
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
End Function