我如何锁定字段的访问，这样用户只能够增加表？我希望用户只能访问添加到表，以保持数据intergity。

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 intergity.

推荐答案

由于您使用Access 2010（或更高版本），可以使用事件驱动的数据宏来限制哪些用户可以做的。为$ P $删除记录pvent他们，你可以使用下面的前删除宏：

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:

如果你也想prevent他们编辑现有记录，你可以使用下面的更改宏之前：

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

有关详细信息，请参阅

创建数据宏