Microsoft Access 2007是否字段问题 [英] Microsoft Access 2007 yes no field problem

问题描述

亲爱的所有人，

我在Microsoft Access 2007中有一个数据库，其中有一个名为下载资源的表，其中有一个是/否"列(复选框)，默认情况下是否"，并且该表中现在有大约15000行，现在我要要做的是查询，可以一次性检查所有复选框..

我已经尝试过以下查询:UPDATE resource SET isdownloaded ="Yes"，其中ResourceId = 10786;

我只想更新一行，但它告诉我您无法更新此记录..

请建议我如何解决此问题...


问候，
Krunal panchal

Dear All,

I have one database in microsoft access 2007 in which there is a table named downloaded resources in which there is a " yes / no " column (checkbox) which is no by default and there are around 15000 rows in that table, now what i want to do is make a query which could check all that checkbox in one go..

I have tried this query: UPDATE resource SET isdownloaded = ''Yes'' where ResourceId = 10786 ;

i am only trying to update one row but it is showing me you cant update this records..

Please suggest me how to resolve this problem...


Regards,
Krunal panchal

推荐答案

当我检查Access 2007中使用的SQL语句时，可以使用其中一个

When I check the SQL statement used in Access 2007 you can use either

UPDATE resource SET isdownloaded = True where ResourceId = 10786 ;

或

or

UPDATE resource SET isdownloaded = Yes where ResourceId = 10786 ;

可能是由另一个程序专门打开的，因此已变为只读.

还是它的设计视图在另一个窗口中打开了，所以您不能更改表?

还是文件是只读的?

而且查询的语法还可以，因此没有其他事情可以想象！

May be its opened exclusively by another program so it has became read only.

Or may be its design view is open in another window so you can not change the tables ?

Or may be the file is readonly ?

And the syntax of query is OK so no other things are imaginable !

使用以下查询将为您提供帮助:

UPDATE资源SET已下载= 1，其中ResourceId = 10786

Use the following query this will help you:

UPDATE resource SET isdownloaded = 1 where ResourceId = 10786

这篇关于Microsoft Access 2007是否字段问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！