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

MartyConnelly martyconnelly at shaw.ca
Tue Aug 23 14:29:42 CDT 2005


I don't know if this will help but you can compile and decompile queries.
http://www.trigeminal.com/lang/1033/codes.asp?ItemID=15#15

Bobby Heid wrote:

>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
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list