Hello,
my Google search didn't help so I'll ask from experts.
I'm having problem with Access 2003 database which has tables, forms, reports, macros and automatic switchboard from startup as a menu where users can select the needed action they want to do.
In the beginning .mdb opened directly to the switchboard but we prefer to protect the database with password from Tools -security. So nowadays it asks password before opening the switchboard.
Now we want to set different user group levels as admin, add/change, add/read and limited read.
But we cannot reset the main password at all because there is no Tools menu as the switchboard is hiding menu items.
There is only File, Edit, Insert, Records, Window and Help
How we can reset/remove the password?
What's best way to give access or limit it depending a group?
Is it possible to hide menu items depending your group in Access?
Thanks a lot!
-e-