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

问题描述

我制作了一个桌面应用程序，然后对其进行了设置.
我将其安装在笔记本电脑中可以正常工作，但是当我将其安装在另一台计算机上时却无法正常工作.

更新或插入时出现错误

I made a desktop application and then made set-up of it.
I installed it in my laptop it works fine, but when I installed it on another computer it does not work.

On updating or inserting I am getting an error

operation must use an updatable query.

我不知道为什么.
有谁知道为什么会这样.

连接字符串是

I don''t know why.
Does anyone know why this is happening.

connection string is

public static string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Application.StartupPath + "\\patientsmanagement.mdb";

推荐答案

检查以确保用户对Access数据库所在的文件夹具有足够的权限，用户需要具有读写权限. > 如果应用程序安装在"Program Files \ Application"中，则用户将无权在Vista和Windows 7上进行写.

还要检查文件是否不是只读文件.

Check to make sure the user has sufficient right on the folder where the Access database is located, the user needs read and write rights.
If the application is installed in "Program Files\Application" the user will have no right to write there on Vista and Windows 7.

Also check if the file is not read-only.

检查以下内容:

操作必须使用可更新的查询. (Microsoft JET数据库引擎) [^ ]

Solving-the-Operation-Must-Use-An- Updateable-Query-error [

check these out:

Operation must use an updateable query. (Microsoft JET Database Engine)[^]

Solving-the-Operation-Must-Use-An-Updateable-Query-error[^]

hope it helps :)

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