If they aren't an ADMIN user, then disable everything for them, but if I login, enable everything for me.

If it's possible, I'd like to do all this using VBA. But if you don’t like Quick Access or you’d prefer to see a traditional navigation pane, you can hide or remove it entirely. But, that could be a little bit of a pain having to do that each time.Īlso, I know I could finish the design and convert the DB to an MDE, but since my DB isn't broken up into a front/back end, I have to access that same DB everyone else uses, and if any changes need to be made, I don't want to have to use my backup, transfer over the changes any user made to the records, and then reconvert it back to an MDE each time. The Quick Access section is available at the left side of the navigation pane in File Explorer, which gives you an easy way to access your frequently used folders or files. I can go to the options menu and disable the nav pane completely, so I know since only I have access to the ribbon, I could always go in each time and recheck the display nav pane option on that menu.

Access hide navigation pane