I had write some statements like below

---------------------------------------------------------------------

    strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                    "Data Source=C:db.mdb"

    objConnection = New OleDbConnection(strConnection)
    objConnection.Open()

    strSQL = "INSERT INTO `Employees` ( `FirstName` , `LastName` VALUES ( 'Teon' , 'Ooi' )"

    objCmd = New OleDbCommand(strSQL, objConnection)

    objCmd.ExecuteNonQuery()

---------------------------------------------------------------------

I run it and get "Operation must use an updateable query" in the browser.

Can anyone help me? I don't know what wrong with it!:(

Data Source=c:/<folder name>/db.mdb

Try that for starters.

Also check security permissions on the database. Make sure the <machine name>\aspnet and iusr_<machine name> accounts have write access to the db or make sure the appropriate people can write to the database.

Can you show me how to check the security permissions on the database and <machine name>\aspnet and iusr_<machine name> accounts' write access?

What Operating System do you have?

I am using WinXP Pro.
Sorry if I cause you trouble.

No problem.

Open 'My Computer'. Click 'Tools' and then 'Folder Options'. Then click on the 'View' Tab and scroll all the way to the bottom. Uncheck 'Use Simple File Sharing(Recommended)' and click 'Ok' or 'Yes' to the warning.

Once that has been done you should be able to go the the folder where your db.mdb is at and right click on the folder and give <machine name>\aspnet and iusr_<machine name> accounts write access to the folder.

I think you are lacking a parenthesis in this

strSQL = "INSERT INTO `Employees` ( `FirstName` , `LastName` VALUES ( 'Teon' , 'Ooi' )"

... you should should be able to do like this...

strSQL = "INSERT INTO Employees VALUES ('Teon', 'Ooi')"

Hope it helps.

Jacob.

It works ! Thank you. :)