[AccessD] ADODB recordset problem

Arthur:
Don't reference a query, go directly to the table to add a record.

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: 06 September 2009 17:41
To: Access Developers discussion and problem solving
Subject: 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