Some Can Read; Some Can Write

[cassidym]

Have a personnel DB I developed for my company and have six users. I only want two of these users to be able to enter and edit data while the remaining four can only view reports.

I have set the DB so that only the switchboard shows when the user opens the DB. Is there a setting that will prevent all but two users I designate to write and edit data?

Thanks

[Datagopherdan]

If you're not using newer than Access 2007, you can use the built in security wizard to set user permissions.

Have a personnel DB I developed for my company and have six users. I only want two of these users to be able to enter and edit data while the remaining four can only view reports.

I have set the DB so that only the switchboard shows when the user opens the DB. Is there a setting that will prevent all but two users I designate to write and edit data?

Thanks

[pkstormy]

I actually set up a 'user' table, grab the login automatically in code, and then code appropriately on the forms to allow editing.

Attached is an example.

[NTC]

or you could make a separate FE for the report readers; that just has the ability to open reports....