Function RecordLocked(rst As Recordset)AsBoolean
Dim blnLock As Boolean
On Error GoToErrorHandler
blnLock=rst.LockEdits '保存LockEdits属性的当前值
rst.LockEdits=True '设置保守式锁定
rst.Edit '试着编辑记录,如果记录被锁定,则会产生错误3197
RecordLocked=False
rst.CancelUpdate
rst.LockEdits=blnLock '恢复LockEdits属性的值
EXit FUnction
ErrorHandler:
Select Case Err
Case 3197:
Resume Next
Case Else
RecordLocked=True
Resume Next
EXit Function
End Select
End Function
Private Sub Command1_Click()
Dim dbs As Database
Dim tb As Recordset
Dim bl As Boolean
Set dbs=opendatabase("c:\dbdir\dbl.mdb",dbopenDynaset)
Set tb=dbs.OpenRecordset("tablel",dbOpenTable)
bl=RecordLocked(tb)
End Sub