Locking tables in Access 2010

Question

How do I lock fields in access so the user is only able to add to table? I want the user to only have access to adding to the table to maintain data integrity.

Answer 1

Since you are using Access 2010 (or later) you can use event-driven Data Macros to restrict what the users can do. To prevent them from deleting records you can use the following Before Delete macro:

If you also want to prevent them from editing existing records you can use the following Before Change macro:

For more information see

Create a data macro