Cannot Use Disconnected Recordsets With Access 2003 Forms

[Will]

We are trying to use disconnected ADO recordsets with Access forms and
having problems. If we disconnect the recordset, change it in code (no
forms included), and then update the database, it works, and the database is
updated. If we disconnect the recordset, bind it to an Access 2003 form,
then try to update the database, it appears to work, but the database is
never actually updated. We suspect that the elements of the recordset
must have some hidden status flags to indicate changes, and that Access
forms simply are not updating those correctly.

Is there a trick that will allow Access 2003 forms to work on disconnected
recordsets and then allow us to update the database using the modified
recordset?

 

[Will]

The bottom line: can we use disconnected recordsets with Access 2003 forms?