WSS 3.0，插入到..选择按列创建/修改
我刚刚在 Access 2007 中构建了一个查询，需要将一些项目从 ListA 移动到 ListB 并保留创建者和修改者列。该查询的工作方式如下所示：
INSERT INTO [ListA] ( [Column1], [Modified By], [Created By] )
SELECT [Column1], [Modified By], [Created By]
FROM [ListB];
问题是“创建者”和“修改者”字段在新列表上更新，以反映实际通过 Access 执行查询的用户。
有什么办法可以解决这个问题还是这只是一个限制？
I've just built a query in Access 2007 that needs to move some items from ListA to ListB and retain the created by and modified by columns. The query works and looks something like this:
INSERT INTO [ListA] ( [Column1], [Modified By], [Created By] )
SELECT [Column1], [Modified By], [Created By]
FROM [ListB];
The problem is the Created By and Modified By fields are updated on the new list to reflect the user that actually executes the query through Access.
Is there any way around this or is it just a limitation?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我不知道这是否可以从 Access 或任何其他最终用户可访问的位置实现。可以通过 SystemUpdate 方法从客户端对象模型实现这一点。 http://programming.cmsstores.com/microsoft- sharepoint-systemupdate-and-update-using-object-model/
I don't know if this is possible from Access or any other end user accessible location. Where this is possible from is the client object model through the SystemUpdate method. http://programming.cmsstores.com/microsoft-sharepoint-systemupdate-and-update-using-object-model/