Solved

Update Error

Posted on 2006-11-24
1
188 Views
Last Modified: 2010-04-16
Recieve a oled db error saying i must use a updateable query

string cmdString_Update = "UPDATE [table 1] SET yn = True WHERE yn=False AND type='avb'";
                   
                    conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/backend.mdb;Persist Security Info=True;Password=**;User ID=user;Mode=Read;Jet OLEDB:System database=c:/sec.mdw");


OleDbCommand mycommand_Update = new OleDbCommand(cmdString_Update, conn);
                           
                           
                           mycommand_Update.ExecuteNonQuery(); <--- Points to this line of code
0
Comment
Question by:ziwez0
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 29

Accepted Solution

by:
Nightman earned 500 total points
ID: 18007007
have a look at http://support.microsoft.com/kb/175168
Shows 4 possible causes.

Although I suspect yours is number 2 - your connection string explicitly sets the mode to Read, not ReadWrite.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question