[AccessD] ADODB recordset problem

Since the code involved has to write to a table in a Word document, I'm now
thinking that trying to append a row to the recordset is pointless, and that
instead I ought to check if the recordset is empty, and if so then update
the bookmarks in the Word document directly. This is beginning to seem
simpler than trying to add a row to the recordset.
A.

On Sun, Sep 6, 2009 at 1:54 PM, Asger Blond <ab-mi at post3.tele.dk> wrote:

> How would you make a union query updatable?
> I know how to do this in SQL Server, but don't think it's possible in
> Access.
> In any case, when opening the ADODB recordset you have to use either
> adLockOptimistic or adLockPessimistic.
>
> Asger
>
>