U Accessovoj bazi postoji samo jedna table 'tablica', jedan record i dva fields 'id' i 'sadrzaj'.
Zanima me gdje grijesim...

moj kod:

string putanja = Server.MapPath("baza.mdb");
string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + putanja;
OleDbConnection conn = new OleDbConnection(connStr);
string sqlUpit = "UPDATE tablica SET sadrzaj = 'jagode' WHERE id = 1";
OleDbCommand cmd = new OleDbCommand(sqlUpit, conn);

conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

ovo je greska koja mi se javi:

System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at web_forma.upis.gumb_ServerClick(Object sender, EventArgs e) in e:\inetpub\wwwroot\web_forma\upis.aspx.cs:line 65

vidi ovo:
http://p2p.wrox.com/topic.asp?TOPIC_ID=35196

mozhda pomogne

Hvala sergej!