Secured Access to Forms

1 Jun 2009 5:37 PM

AccessIM

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.

2 Jun 2009 8:25 AM

Keith Wilby

"AccessIM" <Acces***@discussions.microsoft.com> wrote in message
news:9986ADB4-143C-43FB-8EA4-D900CFF8CDE3@microsoft.com...
> 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