Recordet Property and updatable forms

[Jorge Viñuales]

Hello. I want to assign a Recordset variable to a form's Recordset Property.

When I make it, I can see the records in the underlying Recordset, but I
can't update the records, and I can't insert or delete Records.

¿Why?. With a mdb file there wasn´t any problem. With an ADP file, I
can´t...

Here is my code:

Dim cnn as new connection
dim rst as new ADODB.Recordset

cnn.open "......."
Set rst.ActiveConnection = cnn
rst.CursorLocation=adusecliente
rst.CursorType=adopendynamic
rst.LockType=adLockOptimistic
rst.Open "tb_customers"

set Forms!MyForm.Recordset=rst

Thank you for your help

 

[Sylvain Lafontaine]

See http://support.microsoft.com/default.aspx?scid=kb;EN-US;227053 and
http://support.microsoft.com/?id=281998

I don't know if dynamic cursors will work with Access forms; you should use
keyset cursors instead.

S. L.