Line 95: //				mycommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("@ngay",System.Data.OleDb.OleDbType.DBDate,9,"@ngay"));
Line 96: //				mycommand.Parameters["@ngay"].Value =ngay;
Line 97: 				mycommand.ExecuteNonQuery();
Line 98: 				myconnection.Close();
Line 99: 			}

This is my code:

                ngay = System.DateTime.Today.ToString() ;
                string chuoiketnoi= "provider=microsoft.jet.oledb.4.0;Data Source="+ Server.MapPath("db_head.mdb");
                string insertquery="Insert into tblnews(noidung,ngay) values('"+TextBox1.Text + "'" + "," + "'" + ngay + "')";
                myconnection = new OleDbConnection(chuoiketnoi);
                myconnection.Open();
                mycommand = new OleDbCommand(insertquery,myconnection);
                mycommand.ExecuteNonQuery();
                myconnection.Close();

help me please !!!!!!!

I can't INSERT data

1) There is a securiy detail we must check:  ( The message you got is very misleading, and you should foward it on to microsoft, so that maybe they fix in future ).;

The reason for this error message possibly is that the process runs
under an identity (usually ASPNET) that only has read access
to the database.

Right click on the database file in Windows Explorer, go to the
Security tab, and give the ASPNET user modify rights to the file 

Remember, that Access needs to create the *.ldb (lock) file in the same
directory as the database. Giving rights to just the *.mdb may not be
enough. I like to keep my *.mdb & *.ldb in a subfolder and permission that
instead.

2) Are you sure its the executenon query that is not working and not your command?

Have you tryied writing out yor insertquery and testing it against the accessdb directly?

           Insert into tblnews(noidung,ngay) values('"+TextBox1.Text + "'" + "," + "'" + ngay + "')";

 assuming it does, then we go with number 1 as the lilkley issue.

I don;t know how to repair it,

Please Show me how to do it

I use Access 2003  and C# ASPnet 1.1 

Depending on your operating system - right-click on the folder where your database is kept.

either click on Properties or "Sharing and Security" (whichever) - click on the Security tab - make sure the ASPNet user is in the "Group or user names" list. If not, click the 'Add' button to find and add it.

Then, with that user selected, look at the bottom box (Permissions list) - make sure 'Modify' is checked - then click the Apply button.

That will stop your "Operation must use an updateable query." error message from happening

Dear ipvn,

You may face this error if your MS-Access Database doesnt have the right secuirity permissions, or may be it's open by another process

1- If your file system is FAT32 then the security permissions don't have any effect, there will be no restrictions

2 - If you are using NTFS file system on your hard drive then you should grant ASPNET user account MODIFY level on the .mdb file

If you cant find the Sharing and Security option on the file or the folder do the following:

[ go to FOLDER OPTIONS ----> VIEW ] and make sure that USE SIMPLE FILE SHARING is UNchecked

 3 - Grant MODIFY permission as shown on the other replies to your current post

 4 - Make sure that there is no active connection within your .NET IDE with the databse, if so close that connection

* To prevent errors while using MS-Access databases try your best to keep only one active connection to the database

 I hope that my post is usefull, good luck

I actually pasted this code in another message thread.  It should do what you want.

    Dim insertSQL As String

    insertSQL = "insert into tblusers (username, pwd, datecreated) values " & _
        "(@username, @pwd, @datecreated)"

    Dim conn As New OleDbConnection(connString)
    Dim cmd As New OleDbCommand(insertSQL, conn)

    cmd.Parameters.AddWithValue("@username", txtUserName.Text)
    cmd.Parameters.AddWithValue("@pwd", txtPassword.Text)

    If txtDateCreated.Text = "" Then
        cmd.Parameters.AddWithValue("@datecreated", Now.ToString)
    Else
        cmd.Parameters.AddWithValue("@datecreated", txtDateCreated.Text)
    End If

    Try
        conn.Open()
        cmd.ExecuteNonQuery()
        lblResult.Text = "User Added"
    Catch ex As Exception
        lblResult.Text = ex.Message
    Finally
        conn.Close()
    End Try