如何在表单使用的活动表上运行make table查询？ [英] How to run make table query on an active table used by a form?

问题描述

我试图通过表单更新现有表格。但是，我收到错误数据库引擎无法锁定表tbl_test"因为它已经被另一个人或过程使用了。


请帮我找个办法解决这个问题


谢谢

解决方案

< blockquote> Access专门设计用于阻止您绕过这个，为了您自己的利益。考虑当表格的操作员发现由于记录源消失而突然崩溃时会发生什么。


我建议你退后一步考虑你真正想要的东西，然后看看找到一种合理的方法来实现它。

@NeoPa


NeoPa，<一旦用户通过表单输入数据，我想关闭该表单，运行make table查询并再次打开表单，但我得到的是数据库引擎无法锁定表格 " tbl_test"因为它已经被另一个人或过程使用了错误。你可以建议一下吗？


谢谢

你为什么要重新制作你刚添加数据的表？听起来，一般来说，就像你正在艰难地尝试一项简单的任务。

I am trying to re-create the existing table once it gets updated via form. However, I am getting error "The database engine could not lock table "tbl_test" because it is already used by another person or process".

Please help me find a way to get around this

Thanks

解决方案

Access has been specifically designed to stop you getting around this, for your own good. Consider what would happen when the operator of the form found that it suddenly crashed due to the record source disappearing.

I suggest you take a step back and consider what you actually want, then look at finding a sensible way to implement that.

@NeoPa
NeoPa,

Once user inputs the data via form, I want to close that form, run the make table query and open the form again but I am getting the "The database engine could not lock table "tbl_test" because it is already used by another person or process" error. Can you please suggest a way around?

Thanks

Why are you remaking a table that you just added data too? Sounds, in general, like you''re trying to an easy task the hard way.

这篇关于如何在表单使用的活动表上运行make table查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！