Sub CheckFrozen(strTableName As String)
Dim dbs As Object
Dim tdf As Object
Dim prp As Variant
Const DB_Integer As Integer = 3
Const conPropertyNotFound = 3270 ' 属性没有找到的错.
Set dbs = CurrentDb ' 获得当前数据库对象
Set tdf = dbs.TableDefs(strTableName) ' 获得表对象
DoCmd.OpenTable strTableName, acNormal ' 打开表
tdf.Properties.Refresh
On Error GoTo Frozen_Err
If tdf.Properties("FrozenColumns") > 3 Then ' 检查FrozenColumns 冻结列数 的值
DoCmd.Maximize
End If
Frozen_Bye:
Exit Sub
Frozen_Err:
If Err = conPropertyNotFound Then ' 没有这个属性 则添加这个属性.
Set prp = tdf.CreateProperty("FrozenColumns", DB_Integer, 1)
tdf.Properties.Append prp
Resume Frozen_Bye
End If
End Sub