Recordset不可更新 [英] Recordset not updateable
问题描述
我有一个包含许多表格，查询和表单的数据库。问题实际上在于其中一个表格。此表有一个字段，我之前已将其设置为索引并重复确定。但是现在当我将此属性更改为不重复时，我的表单变得不可更新。
实际上，查询基于此表，并且基于此查询依次处理表单。
请帮我解决这个问题。
I have a database with many tables, queries and forms. The problem actually lies in one of the tables. This table has a field for which i had set previously as indexed and duplicates ok. But now when i change this property to no duplicates then my form becomes not updateable.
Actually a query is based on this table and the form in turn in based on this query.
Please help me solve this problem.
推荐答案
我有包含许多表，查询和表单的数据库。问题实际上在于其中一个表格。此表有一个字段，我之前已将其设置为索引并重复确定。但是现在当我将此属性更改为不重复时，我的表单变得不可更新。
实际上，查询基于此表，并且基于此查询依次处理表单。
请帮我解决这个问题。
I have a database with many tables, queries and forms. The problem actually lies in one of the tables. This table has a field for which i had set previously as indexed and duplicates ok. But now when i change this property to no duplicates then my form becomes not updateable.
Actually a query is based on this table and the form in turn in based on this query.
Please help me solve this problem.
表单后面的查询的完整sql是什么，我们正在讨论哪个字段。
Mary
What is the full sql of the query behind the form and which field are we talking about.
Mary
表单后面的查询的完整sql是什么，我们在谈论哪个字段。
Mary
What is the full sql of the query behind the form and which field are we talking about.
Mary
该字段的数据类型为number。表中此特定字段的属性最初设置为索引：是（重复确定）。但是现在当我试图将属性更改为是（没有重复）时，表单变得不可更新。该表已有主键字段。
有一个基于此和另一个表的查询。并且基于此查询的结果是表单。现在表格是不可更新的。
我希望我清楚？。
The field is of data type number. The property of this particular field in the table was initially set as Indexed : Yes(duplicates ok). But now when i tried to change the property to Yes( no duplicates) then the form became not updateable. This table already has a primary key field.
There is a query based on this and another table. And based on the result of this query is the form. Now the form is un updateable.
I hope im clear ?.
字段是数据类型编号。表中此特定字段的属性最初设置为索引：是（重复确定）。但是现在当我试图将属性更改为是（没有重复）时，表单变得不可更新。该表已有主键字段。
有一个基于此和另一个表的查询。并且基于此查询的结果是表单。现在表格不可更新。
我希望我清楚吗？
The field is of data type number. The property of this particular field in the table was initially set as Indexed : Yes(duplicates ok). But now when i tried to change the property to Yes( no duplicates) then the form became not updateable. This table already has a primary key field.
There is a query based on this and another table. And based on the result of this query is the form. Now the form is un updateable.
I hope im clear ?.
我需要实际查询。如果您不知道如何获取sql然后打开访问查询窗口并将视图更改为sql然后只需复制并通过此处的查询。
我还需要知道我们正在讨论的查询中字段的名称。
Mary
I need the actual query. If you don''t know how to get the sql then open the access query window and change the view to sql then just copy and past the query in here.
I will also need to know the name of the field in the query that we are talking about.
Mary
这篇关于Recordset不可更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
