I need help, please, setting up user level security for a database I need to implement next week.
Question 2: I'm trying to get security set up on a test database. Im probably missing something very simple here but cant figure out what. In a nutshell, when I try to run the Security Wizard Im told I dont have Admins rights, even though Ive logged in as the sole user in the system which is shown to have Admins rights.
Heres the steps Ive gone through:
1. In Access (with all databases closed), I created a new workgroup, saving the MDW file in a sub-folder of the folder holding the database it will secure. Closed Access.
2. Re-opened Access. Went to Security > User & Group a/cs, and created a new user, then gave new user Admins rights and a password. Removed Admins rights from Admin user. Closed Access.
3. Re-opened Access. Went to Security > User & Group a/cs. Logged in as the new user, ignoring the password field. Put in a new password for the new user. (This business of putting in a password the first time, then ignoring it and putting in a second one makes no sense to me but thats what I was advised to do so Ive done it.)
4. Opened the database to be secured. Went to Security > User-Level Security Wizard& and was denied permission.