且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

防止锁定MS Access数据库表

更新时间:2022-12-31 12:58:51

如果您在Access中进行此操作,则Forms,Reports和Queries具有一个RecordLocks属性,该属性控制如何锁定基础数据.
将此设置为无锁定"(0)意味着将使用开放式锁定,并且两个或更多用户可以编辑记录.

如果在访问代码中使用DAO,则LockEdits属性具有相似的效果,当设置为True时,将使用悲观锁定.设置为false时,将进行优化锁定-在执行Update方法之前,页面不会被锁定.
If you''re doing this within Access, Forms, Reports and Queries have a RecordLocks property that controls how the underlying data is locked.

Setting this to "No Locks" (0) should mean that optimistic locking is used, and two or more users can edit the record.

If using DAO in Access Code, then the LockEdits property has a similar effect, when set to True, pessimistic locking is used. When set to false, optimisitic locking - the page is not locked until the Update method is excuted.