Read/Write privilege in Form. Also, how to preventing duplicate entries?

[Biologybook]

I have a database that I would like my employees to be able to populate via a form I created.



Can I limit there read/write ability so that they can only add new entries and not accidentally delete things from the database.

Also, is there a way to make sure they don't enter duplicate data. i.e. Engineer 1 enters information for part number X, but tomorrow Engineer 2 goes to enter same part number X.

If they could see the database table, they could search and see if it had been entered already, but i don't want to give them access to the entire database. Ideally they would just be working with a form and the form wouldn't allow them to enter duplicate entries in the part number field.


Thanks in advance for any insight you can offer me

[June7]

You could open form with properties set according to the user privileges. Common topic, do forurm or Google search. Review

http://www.mrexcel.com/forum/showthread.php?t=248191
https://www.accessforums.net/showthr...ser+permission