I don't now about SQL Server CE but in general ADO supports INSERT/UPDATE/DELETE but you may have to configure connection properties correctly for that. In particular CursorLocation and CursorType. Try to make recordset a client side

CursorLocation = ADUSECLIENT

>I am trying to insert records into a .net local data table (SQL Compact Edition .sdf File)
>
>I am using a cursor adapter since these is no ODBC driver for this.
>
>I can open the table just fine but I cannot get an insert to work. Is it possible to insert into an ADO table?
>
>This is what is being returned by aerror after the tableupdate()
>
> ( 1, 1) N 1435 ( 1435.00000000)
> ( 1, 2) C "Microsoft Cursor Engine : Multiple-step operation generated errors. Check each status value."