Restricting rights to database based on network logon

[JShrimps, Jr.]

Is it possible to restrict access to an Access database based on the logon?
My Startup form checks for the network name of the person who openend the
database. If myself or the data entry person opens the database, we should
have full access. Anyone else should have read-only access.

I have the code to check for the user name before each form opens - and then
open the form read-only if someone else is logged on - but there
are over 25 forms and that wouldn't restrict access to the tables
themselves.

 

[Gary B]

Have you considered the built in security within Access ?

There is a pretty good explaination on "how to" in the
help screens.

Gary