数据库单条记录无法修改，持续触发写入冲突错误求助

问题描述 #

我无法修改数据库表中的某一条记录，当前无其他用户访问该表或数据库，也未打开数据库的其他副本。操作时持续出现写入冲突错误，仅提供「复制到剪贴板」和「放弃更改」两个选项。请问该单条记录出现写入冲突还有其他原因吗？是否可能是VBA代码锁定了这条记录？表中其他记录均可正常编辑，唯有该记录疑似被锁定。

补充信息 #

应要求附上完整的CREATE TABLE语句：

CREATE TABLE [dbo].[2450Other_t1](
    [ID] [int] NOT NULL,
    [UPN] [int] NULL,
    [CRID] [int] NULL,
    [bmt_date] [datetime] NULL,
    [Visit] [nvarchar](5) NULL,
    [ContributingCOD] [nvarchar](40) NULL,
    [NewMalignancyEBV] [nvarchar](5) NULL,
    [DiseaseStatusNorCR] [nvarchar](25) NULL,
    [SUBSEQ_T] [nvarchar](5) NULL,
    [Ind_Subseq] [nvarchar](25) NULL,
    [Source_Subseq] [nvarchar](255) NULL,
    [CellTherapy] [nvarchar](25) NULL,
    [Date_CT] [datetime] NULL,
    [GraftFail] [nvarchar](5) NULL,
    [AGVHDDevelop] [nvarchar](5) NULL,
    [date agvhd] [datetime] NULL,
    [date agvhd prior] [nvarchar](5) NULL,
    [grade at diag] [nvarchar](10) NULL,
    [skin] [int] NULL,
    [gut] [int] NULL,
    [ugi] [int] NULL,
    [liver] [int] NULL,
    [other_sites] [nvarchar](25) NULL,
    [date max agvhd] [datetime] NULL,
    [cghvd develop] [nvarchar](5) NULL,
    [cgvhd persist] [nvarchar](5) NULL,
    [max cgvhd] [nvarchar](10) NULL,
    [date max cgvhd] [datetime] NULL,
    [on steroids] [nvarchar](5) NULL,
    [other ist] [nvarchar](5) NULL,
    [Liver Therapy] [nvarchar](5) NULL,
    [liver agents] [nvarchar](25) NULL,
    [VodDevelop] [nvarchar](5) NULL,
    [vod date] [datetime] NULL,
    [chimerism] [nvarchar](5) NULL,
    [best-no cr] [nvarchar](255) NULL,
    [best pcr] [nvarchar](5) NULL,
    [best pcr detect] [nvarchar](5) NULL,
    [best pcr date] [datetime] NULL,
    [best flow] [nvarchar](5) NULL,
    [best flow detect] [nvarchar](5) NULL,
    [best flow date] [datetime] NULL,
    [best cyto] [nvarchar](5) NULL,
    [best fish] [nvarchar](5) NULL,
    [best fish detect] [nvarchar](5) NULL,
    [best fish date] [datetime] NULL,
    [best karyo] [nvarchar](5) NULL,
    [best karyo detect] [nvarchar](5) NULL,
    [best karyo date] [datetime] NULL,
    [best rad] [nvarchar](5) NULL,
    [best rad detect] [nvarchar](5) NULL,
    [best rad date] [datetime] NULL,
    [best clin] [nvarchar](5) NULL,
    [best clin detect] [nvarchar](5) NULL,
    [best clin date] [datetime] NULL,
    [post-syst] [nvarchar](5) NULL,
    [post drug1] [nvarchar](50) NULL,
    [post drug2] [nvarchar](50) NULL,
    [post drug3] [nvarchar](50) NULL,
    [post drug4] [nvarchar](50) NULL,
    [rlp prior] [nvarchar](5) NULL,
    [rlp intv] [nvarchar](5) NULL,
    [rlp reason intv] [nvarchar](50) NULL,
    [rlp clin] [nvarchar](5) NULL,
    [rlp rad] [nvarchar](5) NULL,
    [rlp cyto] [nvarchar](5) NULL,
    [rlp flow] [nvarchar](5) NULL,
    [rlp pcr] [nvarchar](5) NULL,
    [rlp chim] [nvarchar](5) NULL,
    [rlp date intervent] [datetime] NULL,
    [rlp drug1] [nvarchar](50) NULL,
    [rlp drug2] [nvarchar](50) NULL,
    [rlp drug3] [nvarchar](50) NULL,
    [rlp drug4] [nvarchar](50) NULL,
    [current not cr] [nvarchar](20) NULL,
    [rlp drug5] [nvarchar](50) NULL,
    [rlp drug6] [nvarchar](50) NULL,
    [rlp drug7] [nvarchar](50) NULL,
    [rlp drug8] [nvarchar](50) NULL,
    [MaxSkin] [int] NULL,
    [MaxGut] [int] NULL,
    [MaxUgi] [int] NULL,
    [MaxLiver] [int] NULL,
    [MaxOther] [nvarchar](25) NULL,
    [ScndMalig] [nvarchar](3) NULL,
    [scndMaligDate] [datetime] NULL,
    [2cndDoc] [nvarchar](3) NULL,
    [2NDMALIGDONOR] [nvarchar](7) NULL,
 CONSTRAINT [2450Other_t1$PrimaryKey] PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

问题解答 #

可能的原因 #

• VBA代码锁定：完全有可能。如果表单事件代码（如OnLoad、BeforeUpdate）或后台宏在访问这条记录时未正确释放锁，或者设置了LockEdits = True强制锁定，就会导致记录一直被占用。检查所有涉及该表的VBA逻辑，尤其是针对目标ID记录的操作。
• 记录数据损坏：比如datetime字段存了无效日期、字符字段含不可见控制字符，编辑时数据库校验异常会伪装成写入冲突。可以直接用SQL语句更新这条记录（如UPDATE [2450Other_t1] SET [Visit] = 'test' WHERE ID = 目标ID），判断是界面还是数据库层面的问题。
• 数据库残留行锁：之前的异常操作（如断电、程序崩溃）可能导致行锁未正常释放。重启数据库服务，或用SQL Server的SP_WHO2查看锁定进程并终止（操作前确认安全）。
• 表单记录集缓存问题：如果编辑表单用了动态集记录集，缓存数据与实际数据不一致会触发冲突。重新打开表单，或切换记录集类型为“快照”测试。
• 触发器干扰：表上的触发器在执行时可能锁定记录，或内部逻辑导致更新失败。临时禁用触发器，再尝试编辑记录验证。

排查步骤 #

1. 用纯SQL语句尝试更新记录，定位问题层级。
2. 排查所有涉及该表的VBA代码，检查是否有未释放的锁逻辑。
3. 重启数据库服务，清除残留锁。
4. 查询目标记录的所有字段值，检查是否存在无效数据。
5. 临时禁用触发器，测试编辑操作。

内容的提问来源于stack exchange，提问作者ElphiusMostafa