[AccessD] ADODB recordset problem

Rocky Smolin rockysmolin at bchacc.com
Sun Sep 6 14:14:50 CDT 2009


Can you open the table directly and insert the record?  You know what table
you want it in.  

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Sunday, September 06, 2009 9:41 AM
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




More information about the AccessD mailing list