HOU INSERT DATA ACCESS como inserto datos en access

Me sale debe usar una consulta actualizable, consulto lo mas bien, pero no puedo insertar.

The message is "must use consults updateable"

Dim cn As OdbcConnection

cn = New OdbcConnection("Driver={Microsoft Access Driver (*.mdb)};" & _

"DBQ=c:\1\bd1.mdb;UID=;PWD=")

cn.Open()

Dim xdataset As New DataSet

Dim xcomando As New Odbc.OdbcCommand

vsp="insert into tabla1(nombre)values("ab")

Dim xobjadapter As New Odbc.OdbcDataAdapter(vsp, cn)

xobjadapter.SelectCommand.CommandType = CommandType.Text

xobjadapter.Fill(xdataset)

xconec.Close()

Return xdataset

ScottThomas

no hablo espanol, pero...

no inserto datos en access con xobjadapter.Fill(xdataset).

try:

Dim connection As OdbcConnection = New OdbcConnection("Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\\1\\bd1.mdb;UID=;PWD=")

Dim insertCommand As OdbcCommand = connection.CreateCommand()
insertCommand.CommandText = "insert into tabla1(nombre) values(@nombre)"

Dim parameter As OdbcParameter = New OdbcParameter("@nombre",OdbcType.VarChar)
parameter.Value = "ab"

insertCommand.Parameters.Add(parameter)

Try
connection.Open()
insertCommand.ExecuteNonQuery()
connection.Close()
Finally
If connection.State = ConnectionState.Open Then
connection.Close()
End If
End Try
Johnny Aywah
My Spanish is a little rusty, but it looks like you are running into the equivalent of the "operation must use an updateable query" exception. Using an Access database requires whatever user you are running under (which means the ASPNET user if you are writing an ASP.NET application) has full control under file permissions to the directory where the mdb file is located.
HOU INSERT DATA ACCESS como inserto datos en access