Form Password

[Kyle Friesen via AccessMonster.com]

How do I password protect a subform within a main form? I have a database that tracks project information I only want only certain people to access the edit/view all data subform. Everyone can access the enter new project subform which doesn't allow editing of existing records.
Thanks.

 

[visdev1]

if the user isn't on the access list then i would just make the subform
invisible when the parent form opens.

frmSubForm2_sub.Visible = False

 

[B. Comrie]

The built in security model for access will accomplish this. Hit the F1 key,
then search for security.

B Comrie
http://www.codewidgets.com

How do I password protect a subform within a main form? I have a database

that tracks project information I only want only certain people to access
the edit/view all data subform. Everyone can access the enter new project
subform which doesn't allow editing of existing records.

 

[Kyle Friesen via AccessMonster.com]

great thanks. unfortunately, I messed it up and tried to add a end user
group with view/read only access and now I can not do anything in the
database. It says I must be a member of the Admins group which I did not
create and so do not have a password for. Is there anyway to clear the
security levels I just created?? Thanks.