[AccessD] Protecting a subform with password

I would suggest a small login form as the db opens, then the db knows who is
working in it.  Now build a table of "can use" and a function that checks if
the logged in user can use.  If so then allow the unhide / enable.  I do
something similar to this with controls that only supervisors should have
access to.  I have users, groups, GroupUsers, then objects,
GroupsCanUseObjects.  Of course that is overkill if this is the only object
in the db that you need to protect but if there are many of them then it
makes sense.

John W. Colby
www.ColbyConsulting.com 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia
Sent: Saturday, September 04, 2004 11:59 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Protecting a subform with password


You can build a pwd form where the user can enter this info and upon
successful entry allow access to the subform, but I suspect that this kind
of deployment will eventually grow tiresome.

Typically I create groups, and assing new users to groups... If going w/
full Access Security then of course this makes a ton of sense, but if even
if you're going the route of something lightweight, you can hardcode forms
to allow only members of rolled-your-own groups.  I think it was John Colby
who had a sample of a "light weight" security.  I think that's what you're
looking for.




On Sat, 4 Sep 2004 14:03:16 +0300, Kostas Konstantinidis <kost36 at otenet.gr>
wrote:
> Hi group,
> 
> On a main form I use a button which opens a subform.
> Is it possible to protect the subform asking a password before?
> 
> Thank's
> kostas



-- 
-Francisco
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com