Secured Access to Forms

[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.

 

[Keith Wilby]

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