Microsoft Access 2010 User and Group Permissions are greyed out
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.
I've done a Compile and a Compact and repair.
How do I fix this and why did it happen.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Can I go back to the MDB version?
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.
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.
ASKER
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.
I just liked that I could restrict them from certain forms or reports.
<<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.
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.
ASKER