problem with insert

[mars]

hi
im new in asp.net
trying to insert a record with the following code

dim ncount,connstr1 connStr1 = "Provider=Microsoft.Jet.OLEDB.4.0;data Source=c:\shopingcart1.mdb" 
dim cnAccess1 as New OleDbConnection(connStr1) 
cnAccess1.Open() 
dim cmd as new OleDbCommand 
cmd.Connection = cnAccess1 
cmd.CommandText ="insert into tmporder values (2)" 
nCount = cmd.ExecuteNonQuery() 
label1.text = "Inserted"

getting error "Operation must use an updateable query. "
the table tmporder just have a single number field

if any 1 knows that plz tell me

regards
mars

 

[cjard]

did you miss the field specifier off the insert query?

You wrote:

INSERT INTO table VALUES (values)


I would expect the form to be:

INSERT INTO table(fields) VALUES (values)

 

[lingsn]

Mars code looks fine and it should work.

Please check your mdb is not protected (readonly) and the user is giving the enough permission for the user to connect and update the database.