Help with Insert 1

[dvannoy]

I am trying to insert records using the code below.. I get an error message saying "must use an updatable query" can someone tell me whats wrong with the code?

Dim DBCommand As OleDb.OleDbDataAdapter
Dim DBInsert As New OleDb.OleDbCommand()

Dim dbconn As New OleDb.OleDbConnection( _
"Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=" & Server.MapPath("Database.mdb;&quot)
DBInsert.CommandText = "INSERT INTO table(Field) VALUES ('" & txt.Text & "')"

DBInsert.Connection = dbconn
DBInsert.Connection.Open()
DBInsert.ExecuteNonQuery()
DBInsert.Connection.Close()

Thanks

 

[link9]

Probably don't have write permissions on the directory where the database is.

Ensure that the ASPNET user on the local machine where the app is running has "Modify" permissions (NTFS) on the folder, and see if that clears it up.

 

[dvannoy]

Thank you that was it...