错误“数据库引擎无法锁定表，因为它已被其他用户使用” [英] error "database engine could not lock table because it is already in use by other"

问题描述

嘿伙计，


我有一个包含几个表格和表格的访问数据库。我试图在我的一个表单中添加一个新的组合框，为此我需要将引用的数据添加到我的参考数据表中。简单或者我想，但是在尝试这样做时我得到以下错误数据库引擎无法锁定表，因为它已经被其他人使用了 的。我目前是唯一可以访问此数据库的用户，所以我很遗憾数据库是如何被另一个用户锁定的。


请大家帮忙。

Hey Guys,

I have an access database with a few tables and forms. I was trying to add a new combo box to one of my forms and to do so i needed to add the referenced data to my reference data table. simple or so I thought, but while attempting to do so I got the following error ""database engine could not lock table because it is already in use by other " . I am currently the only user with access to this database so i''m at a lost as to how it is possible that the database is locked by another user.

Please can anyone assist.

推荐答案

您是否打开了表？

尝试将组合框添加到表单中？不，我不这么认为。

While trying to add the combo box to the form? No I don''t think so.

你是否正在使用代码添加到列表中，或者你正在使用可靠的访问控制东西......

and are you using code to add to the list or are you using the horible access control thingie...

这篇关于错误“数据库引擎无法锁定表，因为它已被其他用户使用”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！