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?

 

[onedaywhen]

We suspect that the elements of the recordset
must have some hidden status flags to indicate changes

It sure does. Make changes to the disconnected recordset, save it as
XML (e.g. rs.Save "C:\aaa.xml", adPersistXML) and inspect the contents
of the XML file (e.g. look towards the end of the file for <rs:update>
tags).

Jamie.

--

 

[Will]

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

 

[onedaywhen]

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

Access Forms aren't my forte but one thing worth checking is that you
are using a client-side connection:

? CurrentProject.Connection.CursorLocation = adUseClient
False

Jamie

--