Re: CIRCULAR REFERENCE CAUSED

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 11:07:30 -0600

On Wed, 27 Oct 2004 12:57:54 -0300, "Carl Schuster"
<schus@softhome.net> wrote:

>WHEN RUNNING A QUERIE EVERYTHING WORKS FINE, BUT WHEN TRYING TO EXPORT IT I
>GET THE ERROR "CIRCULAR REFERENCE CAUSED BY "QUERY_NAME""
>
>ANYONE KNOW HOW TO FIX THIS?
>

First off... please lay off the CAPS LOCK key. It's rude, it's hard to
read, and it looks like you're SHOUTING AT US.

Secondly... please crosspost rather than multiposting. If (and it's
rare) you need to post to multiple newsgroups, put all the newsgroups
in the Newsgroups line; this will help those of us who volunteer
identify questions which have already been answered in another group.

Finally... I'm sure I could fix the query, if I could see it. However
I can't, and my telepathic interface is on the blink today. I have to
assume that you have a query named QUERY_NAME which includes a
reference to QUERY_NAME, so the query is calling itself. Could you
open the query in SQL view and post the SQL code here (this one
newsgroup please)?

                  John W. Vinson[MVP]
             Join the online Access Chats
        Tuesday 11am EDT - Thursday 3:30pm EDT
      http://community.compuserve.com/msdevapps

Relevant Pages

  • Re: CIRCULAR REFERENCE CAUSED
    ... When only running this crosstab query it works fine. ... > rare) you need to post to multiple newsgroups, ... I'm sure I could fix the query, ... > open the query in SQL view and post the SQL code here (this one ...
    (microsoft.public.access.queries)
  • RE: Criteria in Queries
    ... Just yo fix what I wrote ... > i haven't been to newsgroups in a while, ... > have a field in a query which contains numbers ranging from -100 to 100. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • RE: 6gw1u4iu
    ... We provided a fix for you that will be available in IDW14. ... SQL Server Data Mining ... OLEDB source (with the DMX prection query) and throw the result into a SQL ... the package fails with the error in the attached ...
    (microsoft.public.sqlserver.datamining)
  • Re: Strange Prediction behavior
    ... We provided a fix for you that will be available in IDW14. ... SQL Server Data Mining ... OLEDB source (with the DMX prection query) and throw the result into a SQL ... the package fails with the error in the attached ...
    (microsoft.public.sqlserver.datamining)
  • Re: Reporting problem
    ... There is no fix for this, except to update each query. ... Does MS have a fix that I can apply to fix the rest of the queries? ... have 2 SMS environments and I would like to get all the queries to work. ... Some are fine and these are all the standard reports. ...
    (microsoft.public.sms.admin)