limit access to certain forms in a database

[Ken]

I need to set up a form so that only certain people can
view and make changes to certain fields in certain
records. But everybody needs access to another form to
add an entire record, but cannot see other records. I
tried using the password option, but that was for the
entire database. Basically, everybody needs access to
enter their information as a record and indicate
which "group" they are in. The person in charge of
say, "group A" needs to be able to view all of "group A"s
records and click a couple "yes/no" boxes to store in the
record. But, the person in charge of "group A" should be
allowed to do this only for "group A" and not B, C, D,
etc.. Or can I use a switchboard that requires a password
to open a certain form? if this is possible, I can just
filter the records for the leader of each group.

 

[Peter De Baets]

There are many alternatives to using Access Security when it comes to
securing your database.

A shareware version of a simplified user security add-in - LASsie
(Light Application Security) for MS Access - is available for download
here:
http://www.peterssoftware.com/las.htm

Also, there's the Access Project Security Manager from
databasecreations, Inc.:
http://www.databasecreations.com/prod_apsm.htm

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com