[AccessD] Weird VSS issue - again. X-posted to Access-L.

Hey all,

We have a fairly large FE with hundreds of queries in it (Acc XP).  There is
this one set of queries that use a pretty complex sub-query.  By complex, I
mean that there are a lot of joins and criteria in it.

Whomever did the original design then self-joined the sub-query 5 times.
This is to handle the tiering of the data.

Any way, after building from source in VSS, this one query would sometimes
be blank.  We finally tracked down how to prevent it from happening.  We had
to view the query in SQL view and then save it.

Well, we just had to add another tier to some other queries (which are like
the ones above) and the same thing happened upon building from source.  I
believe it has something to do with the complexity of the queries.

Does anyone know what might be going on and what we can do to stop it from
happening?  It's becoming a real PIA.

Thanks,
Bobby