Solved

Microsoft Access 2010 User and Group Permissions are greyed out

Posted on 2014-02-21
7
3,196 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
[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
  • 4
  • 3
7 Comments
 
LVL 58

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 58

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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:J.R. Sitman
ID: 39877035
Can I go back to the MDB version?
0
 
LVL 58
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 58
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

627 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