Solved

Microsoft Access 2010 User and Group Permissions are greyed out

Posted on 2014-02-21
7
2,981 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

My experience with Windows 10 over a one year period and suggestions for smooth operation
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

856 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