[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1384
  • Last Modified:

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.
0
LSE_IT_Training
Asked:
LSE_IT_Training
  • 4
1 Solution
 
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 MVP, Access and Data Platform)Commented:
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now