Solved

Access 2003 "User level security wizard" is greyed out

Posted on 2007-03-18
5
718 Views
Last Modified: 2008-02-20
I'm trying to set up user level security in an Access 2003 data base, but under Tools/Security the "User-level Security Wizard" option is greyed out and can't be selected.
How do I enable the wizard ?
0
Comment
Question by:socross
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 70

Accepted Solution

by:
KCTS earned 100 total points
ID: 18743498
Open the requires database. Make sure you have exclusive access. (Use File Open and select the open exclusive option to the right of the filename)
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 150 total points
ID: 18744280
Actually, I don't think that is the issue ... because I have an A2003 mdb open - no Exclusively ... and that menu item is not grayed out.

Do you have a 100% full install in Access - all options were selected when you installed?

mx
0
 
LVL 1

Author Comment

by:socross
ID: 18744337
DatabaseMX is right, but stupidly I had not even opened a database, just the Access application. I now realise that of course the security is tied to a database, not the Access application.

A supplementary question though, before awarding points, if I may, is there a "short cut" command which would open a database in read only mode ( i.e. from a Windows desktop short cut)?

socross


0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 150 total points
ID: 18744366
YES ... I don't know what it is off hand ... no doubt a 'command line; option. I've seen it before in fact.

btw ... no need to feel 'stupid'!  There are NO stupid questions :-}

mx

0
 
LVL 1

Author Comment

by:socross
ID: 18744840
I found the command line switches at http://support.microsoft.com/kb/209207. So mostly I've sorted this one out myself. Never the less I am awarding some points for assistance given.
Thanks.
socross.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question