setting up user level security

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.
LSE_IT_TrainingAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

wiswalldCommented:
At this point are you accessing the db via a shortcut using the mdw file or just clicking a mdb file to open. Shortcut should be something like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\ComplaintLog\Security_Check_Database.mdb" /WRKGRP"\\C:\ComplaintLog\SYSTEM1.mdw"
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
LSE_IT_Training

1) Please close your other Q.
2) Please read over the material in the links in the other Q.  ULS is a non-trivial subject and you *need* to get the background first.  If you follow the steps in the Joan Wild articles - you will be off to a great start.

mx
0
LSE_IT_TrainingAuthor Commented:
I am accessing the db (and opening Access) by clicking on the icon in Windows Explorer - my usual method.  Surely any standard method to open the database should work?

Just to make sure I wasn't missing something obvious, I deleted the previous MDW file I'd created (which caused the problem above) and have just worked through the instructions attached TO THE LETTER, with exactly the same result.  (The link to these instructions was kindly posted as part of a response to the other question I posted.)  I've pasted in screen shots and the <passwords> I used at each step so you can see EVERYTHING I have done.  This is doing my head in.  Last night I reinstalled Access to ensure my laptop hadn't somehow corrupted the program, causing this bug.  I will be infinitely grateful if someone can point out what is causing this problem.
Securing-CIWBD1-33SecurityTest-m.doc
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

LSE_IT_TrainingAuthor Commented:
Having read through more of the links provided in answer to my other question, I've just logged in with each of the only 2 users in the user group.  It is possible to log in as each of them.  However,  neither one is recognised as being a member of Admins when I try to access the User-Level Security Wizard, although the user I added is listed as an Admins group member.  How/why can this be?
0
LSE_IT_TrainingAuthor Commented:
I've now run through another of the docs linked to comments on my 1st question yesterday, with identical results to my comment above. I can log in as either of the only 2 users in the user group.  However,  neither one is recognised as being a member of Admins when I try to access the User-Level Security Wizard, although the user I added is listed as an Admins group member.  (Please see doc attached, showing screen shots at each step).  How/why can this be?  What can I do about it?

Note: the doc attached to my comment at 9:36 pm GMT last night showed results of working through the insx at http://www.jmwild.com/security02.htm 
The doc attached here show results of working through the virtually identical steps (with some useful added explanation) at another of the links kindly supplied yesterday.

I'm finding the links supplied yesterday extremely useful in filling many gaps in my knowledge of user level security -- many thanks -- but they all assume you can use the wizard.
SundaySecuritySetup03Feb.doc
0
LSE_IT_TrainingAuthor Commented:
The problem above was finally resolved by reinstalling Access, creating a new user account on my laptop, transferring the database into the Shared Docs folder and working in the new user account.  Previously Access had been creating a second MDW file whenever I created one, and then somehow mixing the various user IDs and passwords between the two so that none actually worked.

The documents provided were a great help in all kinds of other ways -- many thanks -- but didn't help with this particular problem.  In any case, its now resolved so lets consider this problem closed.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.