Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Microsoft Access 2010 User and Group Permissions are greyed out

Posted on 2014-02-21
7
Medium Priority
?
3,384 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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

886 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