操作必须使用可更新的查询 [英] Operation must use an updateable query

问题描述

我一直在使用SQL Server 2005 for ASP.NET应用程序，但由于某些原因需要
，不得不恢复到MS-Access 2000.


当我尝试插入/更新MS-Access数据库表（MDB）时，ASP.NET

会产生以下错误：


操作必须使用可更新的查询。


指向一行说明


oledbCmd.ExecuteNonQuery（）


我试图在Access数据库中执行一个查询（使用OledbCommand对象）

。


我已经完成了大量文章克服这个错误&

得出的结论是一致的&这个错误背后最常见的原因是

，包含Access MDB文件的目录没有

必备的Write&修改权限。


我导航到MDB文件所在的目录Windows

资源管理器，右键单击目录&点击属性。在安全选项卡下，我点击了添加按钮，打开了一个名为选择用户或组的
对话框。在这个对话框中，我点击了

''高级...''按钮，打开另一个具有相同标题的对话框

''选择用户或组''。在这个对话框中，我点击了''立即查找''

按钮，其中列出了我机器中现有的用户/组。 ASPNET&

IUSR_MYPC（其中''MYPC''是机器名称）被列出。我选择了

他们两个 - 一个接一个 - &给了他们两个''完全控制''

权限，但仍然存在错误。


有人可以帮我解决这个错误吗？它让我疯了

自上次超过3小时!!


我正在使用WinXP Pro SP2。

解决方案

你是否也检查过mdb文件本身没有readonly位设置？


-

Teemu Keiski

AspInsider，ASP.NET MVP
http://blogs.aspadvice.com/joteke
http ：//teemukeiski.net

" Arpan" < ar ****** @ hotmail.comwrote in message

news：11 ********************* @ a34g2000cwb。 googlegro ups.com ...

>我一直在使用SQL Server 2005 for ASP.NET应用程序，但

由于一些原因，不得不恢复到MS-Access 2000.


当我尝试插入/更新MS-Access数据库表（MDB）时，ASP.NET

生成以下错误：


操作必须使用可更新的查询。


指向一行说明
< br $>
oledbCmd.ExecuteNonQuery（）

我正在尝试执行一个查询（使用OledbCommand对象）

存在于Access中数据库。


我已经通过大量文章来克服这个错误&

得出的结论是一致的&这个错误背后最常见的原因是

，包含Access MDB文件的目录没有

必备的Write&修改权限。


我导航到MDB文件所在的目录Windows

资源管理器，右键单击目录&点击属性。在安全选项卡下，我点击了添加按钮，打开了一个名为选择用户或组的
对话框。在这个对话框中，我点击了

''高级...''按钮，打开另一个具有相同标题的对话框

''选择用户或组''。在这个对话框中，我点击了''立即查找''

按钮，其中列出了我机器中现有的用户/组。 ASPNET&

IUSR_MYPC（其中''MYPC''是机器名称）被列出。我选择了

他们两个 - 一个接一个 - &给了他们两个''完全控制''

权限，但仍然存在错误。


有人可以帮我解决这个错误吗？它让我疯了

自上次超过3小时!!


我正在使用WinXP Pro SP2。

是Teemu ....我确实检查过...... MDB文件没有标记为读 -

。


我还能做什么？ Pleassssssssse给我一个具体的解决方案。


1月27日晚上8:44，Teemu Keiski < jot ... @ aspalliance.comwrote：

您是否还检查过mdb文件本身是否没有readonly位设置？
< br $>
-

Teemu Keiski

AspInsider，ASP.NET MVPhttp：//blogs.aspadvice.com/jotekehttp：//teemukeiski.net


" Arpan" < arpan ... @ hotmail.comwrote in messagenews：11 ********************* @ a34g2000cwb.go oglegroups.com ...
< blockquote class =post_quotes>
我一直在使用SQL Server 2005 for ASP.NET应用程序，但由于某些原因，不得不恢复到MS-Access 2000.
。 b $ b

当我尝试插入/更新MS-Access数据库表（MDB）时，ASP.NET

生成以下内容错误：

操作必须使用可更新的查询。

指向一行表示

oledbCmd.ExecuteNonQuery（ ）

我试图在Access数据库中执行一个查询（使用OledbCommand对象）

。

我已经通过大量文章来克服这个错误&

得出的结论是一致的&这个错误背后最常见的原因是

，包含Access MDB文件的目录没有

必备的Write&修改权限。

我导航到MDB文件所在的目录窗口

资源管理器，右键单击目录&点击属性。在安全选项卡下，我点击了添加按钮，打开了一个名为选择用户或组的
对话框。在这个对话框中，我点击了

''高级...''按钮，打开另一个具有相同标题的对话框

''选择用户或组''。在这个对话框中，我点击了''立即查找''

按钮，其中列出了我机器中现有的用户/组。 ASPNET&

IUSR_MYPC（其中''MYPC''是机器名称）被列出。我选择了

他们两个 - 一个接一个 - &给了他们两个''完全控制''

权限，但仍然存在错误。

有人可以帮我解决这个错误吗？这让我疯了

自上次超过3小时!!

我正在使用WinXP Pro SP2.-隐藏引用的文字 - 显示引用的文字 -

你可以随时开始给每个人写入目录的访问权限，并且IIS中的
确保web应用程序为该目录启用写入 - 然后一次

你让它适合每个人，开始限制谁可以使用写入权限访问

目录


-

问候


John Timney（MVP）
http://www.johntimney.com
http：// www.johntimney.com/blog

" Arpan" < ar ****** @ hotmail.comwrote in message

news：11 ********************** @ v45g2000cwv .googlegr oups.com ...

是的Teemu ....我确实检查过...... MDB文件没有标记为read-

only。


我还能做什么？ Pleassssssssse给我一个具体的解决方案。


1月27日晚上8:44，Teemu Keiski < jot ... @ aspalliance.comwrote：

>你还检查过mdb文件本身没有readonly位
设置？

- Teemu Keiski
AspInsider，ASP.NET
MVPhttp：//blogs.aspadvice.com/jotekehttp：//teemukeiski.net

Arpan < arpan ... @ hotmail.comwrote in
messagenews：11 ********************* @ a34g2000cwb.g ooglegroups.com ...

>我一直在使用SQL Server 2005 for ASP.NET应用程序，但是由于某些原因，

，不得不恢复为MS-Access 2000.

当我尝试插入/更新MS-Access数据库表（MDB）时，ASP.NET

生成以下错误：

操作必须使用可更新的查询。

指向一行表示

oledbCmd.ExecuteNonQuery（ ）

我试图在Access数据库中执行一个查询（使用OledbCommand对象）

。

我已经通过大量文章来克服这个错误&

得出的结论是一致的&这个错误背后最常见的原因是

，包含Access MDB文件的目录没有

必备的Write&修改权限。

我导航到MDB文件所在的目录窗口

资源管理器，右键单击目录&点击属性。在安全选项卡下，我点击了添加按钮，打开了一个名为选择用户或组的
对话框。在这个对话框中，我点击了

''高级...''按钮，打开另一个具有相同标题的对话框

''选择用户或组''。在这个对话框中，我点击了''立即查找''

按钮，其中列出了我机器中现有的用户/组。 ASPNET&

IUSR_MYPC（其中''MYPC''是机器名称）被列出。我选择了

他们两个 - 一个接一个 - &给了他们两个''完全控制''

权限，但仍然存在错误。

有人可以帮我解决这个错误吗？这让我疯了

自上次超过3小时!!

我正在使用WinXP Pro SP2.-隐藏引用的文字 - 显示引用的文字 -

I have always been working with SQL Server 2005 for ASP.NET apps but
due to some reasons, had to revert back to MS-Access 2000.

When I try to insert/update a MS-Access DB table (MDB), ASP.NET
generates the following error:

Operation must use an updateable query.

pointing to a line that says

oledbCmd.ExecuteNonQuery()

I am trying to execute a Query (using the OledbCommand object) that
exists in the Access database.

I have gone through heaps of articles to overcome this error &
concluded that the unanimous & most common reason behind this error is
that the directory which houses the Access MDB file doesn''t have the
requisite Write & Modify permissions.

I navigated to the directory where the MDB file resides in Windows
Explorer, right-clicked the directory & clicked ''Properties''. Under
the ''Security'' tab, I clicked the ''Add'' button which opened a dialog
titled ''Select Users or Groups''. In this dialog, I clicked the
''Advanced...'' button which opened another dialog with the same title
''Select Users or Groups''. In this dialog, I clicked the ''Find Now''
button which listed the users/groups existing in my machine. ASPNET &
IUSR_MYPC (where ''MYPC'' is the machine name) were listed. I selected
both of them - one by one - & gave both of them ''Full Control''
permissions but still the error persists.

Can someone please help me resolve this error? It''s driving me nuts
since last more than 3 hours!!

I am working on WinXP Pro SP2.

解决方案

Did you also check that the mdb file itself doesn''t have readonly bit set?

--
Teemu Keiski
AspInsider, ASP.NET MVP
http://blogs.aspadvice.com/joteke
http://teemukeiski.net
"Arpan" <ar******@hotmail.comwrote in message
news:11*********************@a34g2000cwb.googlegro ups.com...

>I have always been working with SQL Server 2005 for ASP.NET apps but
due to some reasons, had to revert back to MS-Access 2000.

When I try to insert/update a MS-Access DB table (MDB), ASP.NET
generates the following error:

Operation must use an updateable query.

pointing to a line that says

oledbCmd.ExecuteNonQuery()

I am trying to execute a Query (using the OledbCommand object) that
exists in the Access database.

I have gone through heaps of articles to overcome this error &
concluded that the unanimous & most common reason behind this error is
that the directory which houses the Access MDB file doesn''t have the
requisite Write & Modify permissions.

I navigated to the directory where the MDB file resides in Windows
Explorer, right-clicked the directory & clicked ''Properties''. Under
the ''Security'' tab, I clicked the ''Add'' button which opened a dialog
titled ''Select Users or Groups''. In this dialog, I clicked the
''Advanced...'' button which opened another dialog with the same title
''Select Users or Groups''. In this dialog, I clicked the ''Find Now''
button which listed the users/groups existing in my machine. ASPNET &
IUSR_MYPC (where ''MYPC'' is the machine name) were listed. I selected
both of them - one by one - & gave both of them ''Full Control''
permissions but still the error persists.

Can someone please help me resolve this error? It''s driving me nuts
since last more than 3 hours!!

I am working on WinXP Pro SP2.

Yes Teemu....I did check that......the MDB file is not marked read-
only.

What else can I do? Pleassssssssse give me a concrete solution.

On Jan 27, 8:44 pm, "Teemu Keiski" <[e-mail]:

Did you also check that the mdb file itself doesn''t have readonly bit set?

--
Teemu Keiski
AspInsider, ASP.NET MVPhttp://blogs.aspadvice.com/jotekehttp://teemukeiski.net

"Arpan" <[e-mail] in messagenews:11*********************@a34g2000cwb.go oglegroups.com...

I have always been working with SQL Server 2005 for ASP.NET apps but
due to some reasons, had to revert back to MS-Access 2000.

When I try to insert/update a MS-Access DB table (MDB), ASP.NET
generates the following error:

Operation must use an updateable query.

pointing to a line that says

oledbCmd.ExecuteNonQuery()

I am trying to execute a Query (using the OledbCommand object) that
exists in the Access database.

I have gone through heaps of articles to overcome this error &
concluded that the unanimous & most common reason behind this error is
that the directory which houses the Access MDB file doesn''t have the
requisite Write & Modify permissions.

I navigated to the directory where the MDB file resides in Windows
Explorer, right-clicked the directory & clicked ''Properties''. Under
the ''Security'' tab, I clicked the ''Add'' button which opened a dialog
titled ''Select Users or Groups''. In this dialog, I clicked the
''Advanced...'' button which opened another dialog with the same title
''Select Users or Groups''. In this dialog, I clicked the ''Find Now''
button which listed the users/groups existing in my machine. ASPNET &
IUSR_MYPC (where ''MYPC'' is the machine name) were listed. I selected
both of them - one by one - & gave both of them ''Full Control''
permissions but still the error persists.

Can someone please help me resolve this error? It''s driving me nuts
since last more than 3 hours!!

I am working on WinXP Pro SP2.- Hide quoted text -- Show quoted text -

You could always start by giving everyone write access to the directory, and
in IIS ensure the web app is write enabled for that directory - then once
you have it working for everyone, start limiting who can access the
directory with write permissions

--
Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog
"Arpan" <ar******@hotmail.comwrote in message
news:11**********************@v45g2000cwv.googlegr oups.com...

Yes Teemu....I did check that......the MDB file is not marked read-
only.

What else can I do? Pleassssssssse give me a concrete solution.

On Jan 27, 8:44 pm, "Teemu Keiski" <[e-mail]:

>Did you also check that the mdb file itself doesn''t have readonly bit
set?

--
Teemu Keiski
AspInsider, ASP.NET
MVPhttp://blogs.aspadvice.com/jotekehttp://teemukeiski.net

"Arpan" <[e-mail] in
messagenews:11*********************@a34g2000cwb.g ooglegroups.com...

>I have always been working with SQL Server 2005 for ASP.NET apps but
due to some reasons, had to revert back to MS-Access 2000.

When I try to insert/update a MS-Access DB table (MDB), ASP.NET
generates the following error:

Operation must use an updateable query.

pointing to a line that says

oledbCmd.ExecuteNonQuery()

I am trying to execute a Query (using the OledbCommand object) that
exists in the Access database.

I have gone through heaps of articles to overcome this error &
concluded that the unanimous & most common reason behind this error is
that the directory which houses the Access MDB file doesn''t have the
requisite Write & Modify permissions.

I navigated to the directory where the MDB file resides in Windows
Explorer, right-clicked the directory & clicked ''Properties''. Under
the ''Security'' tab, I clicked the ''Add'' button which opened a dialog
titled ''Select Users or Groups''. In this dialog, I clicked the
''Advanced...'' button which opened another dialog with the same title
''Select Users or Groups''. In this dialog, I clicked the ''Find Now''
button which listed the users/groups existing in my machine. ASPNET &
IUSR_MYPC (where ''MYPC'' is the machine name) were listed. I selected
both of them - one by one - & gave both of them ''Full Control''
permissions but still the error persists.

Can someone please help me resolve this error? It''s driving me nuts
since last more than 3 hours!!

I am working on WinXP Pro SP2.- Hide quoted text -- Show quoted text -

这篇关于操作必须使用可更新的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！