Solved

Microsoft Access 2010 User and Group Permissions are greyed out

Posted on 2014-02-21
7
3,042 Views
Last Modified: 2014-02-21
For some unknown reason all of a sudden I can't access the User and Group permissions.  I've opened several of the frontends mdb (backup copies) and they all are greyed out.

I've done a Compile and a Compact and repair.  

How do I fix this and why did it happen.
0
Comment
Question by:J.R. Sitman
  • 4
  • 3
7 Comments
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39876887
Are you working with MDB's or ACCDB's?

If the latter, there is no user and groups anymore, or more accurately, work group security is not usable in the ACCDB format.

Jim.
0
 

Author Comment

by:J.R. Sitman
ID: 39876943
I recently converted to ACCDB.  So when I create new forms or reports, how do I give access to the users?
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39877021
<<I recently converted to ACCDB.  So when I create new forms or reports, how do I give access to the users? >>

  You don't.  Work group security was removed (actually it's there, but you can't do anything with it any more).

  Any protection you want on forms and what not you need to build into the app and distribute as a accde so they can't modify the code.  

  But even with that, there is no real way to protect the data.  if they have a full version of Access and know where the DB is, they will be able to get at the data.

Jim.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:J.R. Sitman
ID: 39877035
Can I go back to the MDB version?
0
 
LVL 57
ID: 39877147
You can't take the accdb you have now and go backwards.  All the ACL's (Access control lists) were stripped out during the conversion.

It would have to be a backup or create a new MDB, import everything into it from the accdb, and re-create the users, groups, and permissions.

Jim.
0
 

Author Closing Comment

by:J.R. Sitman
ID: 39877334
This sucks, but thanks for clarifying.  I'll attempt to go back to MDB.  I don't know how to build security into the APP.  I'm not worried about users getting in.  Trust me they have no clue.
I just liked that I could restrict them from certain forms or reports.
0
 
LVL 57
ID: 39877373
<<This sucks, but thanks for clarifying. >>

 Access work group security wasn't all that useful anyway.  It was easily crackable and hard to understand for many.

<<I just liked that I could restrict them from certain forms or reports. >>

 It's fairly straight forward:

1. Create a table with the objects in the database.
2. Create a table with the permissions for those objects
3. When you open an object (like a report), check the table.  If the user is not listed, cancel the open.

  The only hang up here is that you must distribute as a MDE so they can't get at the code.  You'd also code in that the app can't run in anything but runtime mode.

Jim.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

685 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