[AccessD] ADODB recordset problem

One method you can use is to create a data class and collection class.
If there are records, fill the collection class with data classes, if
not, create a single data class with your message.  Then just use your
classes to display the data, instead of a recordset.

This is the 'unbound' solution.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Sunday, September 06, 2009 11: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
The information contained in this transmission is intended only for the person or entity 
to which it is addressed and may contain II-VI Proprietary and/or II-VI Business 
Sensitive material. If you are not the intended recipient, please contact the sender 
immediately and destroy the material in its entirety, whether electronic or hard copy. 
You are notified that any review, retransmission, copying, disclosure, dissemination, 
or other use of, or taking of any action in reliance upon this information by persons 
or entities other than the intended recipient is prohibited.