Microsoft Access: Setting up usergroups and passwords
I need assistance setting up an admin and user passwords with respective permissions. Right now, the only option I've gotten to work is setting up a database password and the problem with that is that any user can mess with the design and settings once they type the correct password in.
I've disabled the database toolbars, etc.. so the only way to get them active is to hold down SHIFT while loading the database which the average user doesn't know.. but what we really want to do is create two usergroups:
Group 1 = Admin (full rights)
Group 2 = User (can run, add/edit records, no design modes enabled)
I've tried running the wizard and that was a disaster.