Cannot Use Disconnected Recordsets With Access 2003 Forms


W

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?
 
Ad

Advertisements

O

onedaywhen

Will said:
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.

--
 
Ad

Advertisements

O

onedaywhen

Will said:
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

--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top