access 批量update遇到问题
UPDATE InFlow INNER JOIN [Platform] ON (((InFlow.platform)=[Platform].[PLATFORM_ID])) SET InFlow.POINT_X = Platform.POINT_X, InFlow.POINT_Y = Platform.POINT_Y
结果是“操作或事件已被禁用模式阻止”,我是想把Platform里面的POINT_X 和POINT_Y字段根据InFlow.platform=Platform.PLATFORM_ID来复制到InFlow表里面去。