[AccessD] ADODB recordset problem

Of course it's possible to do a union on a non-updatable query.  Union
queries aren't updatable anyhow, so what difference would that make?

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Sunday, September 06, 2009 10:53 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] ADODB recordset problem

Sounds like a great idea, but I have no idea how to implement it. But
I'll do some reading and see what I can come up with.
Before I go down that road, though, is it possible to do a Union on a
non-updatable query? If so, I could leave most of the code as is, do a
union and then test how many rows there are in the recordset. If the
count is 1, it means that the query returned no rows. If the count is
>1, then I step around the unioned row.

Thanks for your input.
A.