本文介绍了在Access 2010中锁定表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我如何锁定字段的访问,这样用户只能够增加表?我希望用户只能访问添加到表,以保持数据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:
有关详细信息,请参阅
这篇关于在Access 2010中锁定表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!