Form Password

  • Thread starter Thread starter Kyle Friesen via AccessMonster.com
  • Start date Start date
K

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.
 
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
 
The built in security model for access will accomplish this. Hit the F1 key,
then search for security.

B Comrie
http://www.codewidgets.com

Kyle Friesen via AccessMonster.com said:
How do I password protect a subform within a main form? I have a database
Click to expand...
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.
 
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.
 
Back
Top