[AccessD] Record security

I built a full on user/groups table pair and class system to pull the info
when the database loads.  I have a login form that opens and which the user
has to successfully fill out before the FE will open, from which I capture
the UserID.

Having that I then have a function similar to 

	UserInGroup(UserID, GroupID)

I can then make "rules" in the FE that says specific groups (or users) can
edit / see / use specific things, whether that be forms, controls on forms,
properties of controls / forms etc.

So for example, I when it loads, I can have a form check whether a user is
allowed to view the data at all, or whether the group that the user belongs
to can edit the data etc.

Having a full blown system like this built into my framework makes all kinds
of checks dead simple.


John W. Colby
www.ColbyConsulting.com 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Eget
Sent: Sunday, April 02, 2006 6:20 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Record security

Anyone
In this database, each record entry has an individual field for name.   I
would like anyone to view another individuals records but I am trying to
prevent another individual from editing or deleting a record that does not
belong to them.  Does someone have an example of a login process and then
disabling a record from being deleted or edited by another individual.  I
tried the security wizard but I could not seem to get it to work.  There is
a delete and edit buttons on the form for each record displayed 
Thanks for the help
John
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com