I am creating a project tracking database with a main menu to run reports and update data. I would like to add an "administrator" menu, which allows access to forms that allow full editing of the data. I just don't know how to have a password prompt when a user clicks on a "button" to open a form with a menu for database maintenance.
I do have the database protected to disable the shift launch button keep users from access the full database structure, but am trying to make it easier to give someone full access to edit the database without having to constantly exit the database.
Any help/suggestions would be much appreciated!