Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Microsoft Access 2010 User and Group Permissions are greyed out

Posted on 2014-02-21
7
Medium Priority
?
3,454 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 58

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 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 2000 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

This is an article on how to answer questions, earn points and become an expert.
This holiday season, we’re giving away the gift of knowledge—tech knowledge, that is. Keep reading to see what hacks, tips, and trends we have wrapped and waiting for you under the tree.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

581 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