Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-28-2004, 07:51 AM   #1
Kaya3109
Guest
 
Posts: n/a
Question Record protection - user security access

Hello all,

I have a question about security. I do not know if it is at all possible but I will ask you anyway. I have a database that is used by multiple users and everyone has access to everything within that DB. As you can imagine this causes some problems from time to time. I was wondering if there is a way to secure records, meaning allowing one group of users access to certain records while restricting access for others all based on a project name or project ID. To simplify it even more when user opens a form that displays all projects I would like the DB to determine if the user is a group user and then follow these rules: Users in group 1 can view only information for projects A, B, C and users in group 2 can only view information in projects X, Y, Z, while users in group 3 can view all information about all of the projects.

Thank you,

Any help would be greatly appreciated

  Reply With Quote
Old 12-28-2004, 02:53 PM   #2
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,165
Thanks: 15
Thanked 1,576 Times in 1,498 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Jet security doesn't provide record level control. It only controls objects. You would need to do this yourself with queries and code behind the forms. The problem of course is that you would first have to use the native Jet secuity to lock down the database. If you don't, you can't prevent users from circumventing your user implemented security.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 12-30-2004, 01:34 PM   #3
Kaya3109
Guest
 
Posts: n/a
Thank you.

Then I have another question, would password protected form still allow multiple users to view the database at the same time or it would take away this functionality? Is it possible to set up password for each user, not just one generic password for everyone?

Thank you

  Reply With Quote
Old 12-30-2004, 02:02 PM   #4
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,165
Thanks: 15
Thanked 1,576 Times in 1,498 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Security does not impede database sharing. You can assign individual passwords by using the built in security. Before you do anything regarding Access security, read the Security FAQ. Have a drink. Get a good night's sleep and then read it again. Access security is very tricky and is easy to mess up. Make sure you have at least two backups in safe places.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 12:58 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World