Solved

Update Error

Posted on 2006-11-24
1
181 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
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
What is MicroStrategy.NET? 2 45
Default parameter problem in C# 3 27
Pass through dll 2 37
ASP.NET Web API or ASP.NET Core MVC? 3 25
Extention Methods in C# 3.0 by Ivo Stoykov C# 3.0 offers extension methods. They allow extending existing classes without changing the class's source code or relying on inheritance. These are static methods invoked as instance method. This…
This article introduced a TextBox that supports transparent background.   Introduction TextBox is the most widely used control component in GUI design. Most GUI controls do not support transparent background and more or less do not have the…
This video discusses moving either the default database or any database to a new volume.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now