Re: Secured Access to Forms
- From: "Keith Wilby" <here@xxxxxxxxx>
- Date: Tue, 2 Jun 2009 09:25:51 +0100
"AccessIM" <AccessIM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9986ADB4-143C-43FB-8EA4-D900CFF8CDE3@xxxxxxxxxxxxxxxx
Is is possible to not require a password to open a database (i.e. anyone
could open and have read-only access) but when users try to open certain
forms they are prompted to enter a user name and password in order to open
the form and enter data?
Currently I set security up on a database but it prompts for a password to
even open up the main menu. I would like anyone to be able to view the
database and info within but only certain users can change the data within.
Thanks in advance.
I would create a "guest" user account and make it a member of a "guests" group. Then I would allow this group read-only permissions to all areas. I would then deny access to this group to the forms I don't want it to open. I would not assign a password to the guest account. If I want users to log in as "guest" without having to enter the user name I would provide a shortcut and use the "/user" command line switch.
It might help you to understand user level security if you read and digest the FAQ. There's a link to it on my web site.
HTH - Keith.
www.keithwilby.co.uk
.
- References:
- Secured Access to Forms
- From: AccessIM
- Secured Access to Forms
- Prev by Date: Re: users set their own password
- Next by Date: RE: Access 2007 "compact and repair" asking password
- Previous by thread: Secured Access to Forms
- Next by thread: Re: Workgroup problem
- Index(es):
Relevant Pages
|
