[AccessD] ADODB recordset problem

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

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Arthur Fuller
Sendt: 6. september 2009 18:41
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] ADODB recordset problem

That's it, Rocky. The query is not updatable. I'll have to figure another
way around this problem. Maybe I can do what I need to by changing it into a
union query. I'll experiment.
Arthur

On Sun, Sep 6, 2009 at 10:17 AM, Rocky Smolin <rockysmolin at bchacc.com>wrote:

> A guess: the query is not updateable.  Run the query a la carte and see if
> you can add a record to it manually.
>
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com