Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Query Reverts To Previously Saved Version

Discussion in 'Information Technology' started by Smartin, Jul 28, 2006.

  1. Smartin

    Smartin
    Expand Collapse
    Guest

    Hello All,

    Using Access 97. This is just a curiosity I am wondering if anyone else
    has experienced.

    I have a query like

    01) SELECT Soups, Nuts FROM MyTable WHERE Soups IN (
    02) 'paste', 'your', 'soups', 'here'
    03) );

    FWIW MyTable is a linked table in another A97 database.

    I reuse this query daily by pasting new values in the IN list on line 02
    and immediately running it.

    Occasionally the results match {'paste', 'your', 'soups', 'here'} (i.e.,
    the saved version of the query) rather than the new values I pasted only
    moments before. When I switch to the SQL view, sure enough, my newly
    pasted values are gone and the query has reverted to the saved version.
    This happens sporadically, sometimes daily, other times maybe once a week.

    Has anyone seen this behavior?

    The work-around, which is simple enough, is to save the query with the
    new values before running it. The only objection to doing this is it
    strips the "instructions" for other users.


    --
    Smartin
     
  2. Loading...

    Similar Threads Forum Date
    Query about Jhatka Meat by Shooting in Head Sikh Sikhi Sikhism Aug 26, 2011
    Who is a sikh? A non sikh friend's query!! Sikh Sikhi Sikhism Apr 30, 2010
    General Query Hard Talk Sep 4, 2008
    Power of pauri's in Japji Sahib query Sikh Sikhi Sikhism Aug 17, 2006
    Sikhism a query Book Reviews & Editorials Aug 2, 2005

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    a lot of times

    no help

    Pieter

    ps
    usually making sure all objects are "killed" (ie set obj =nothing) +
    repair, compact & decompile tends to ward it of - most times <g>


    "Smartin" <smartin108@yahoo.com> wrote in message
    news:8f6dnaL4tJMWFijZnZ2dnUVZ_s2dnZ2d@giganews.com...
    > Hello All,
    >
    > Using Access 97. This is just a curiosity I am wondering if anyone else
    > has experienced.
    >
    > I have a query like
    >
    > 01) SELECT Soups, Nuts FROM MyTable WHERE Soups IN (
    > 02) 'paste', 'your', 'soups', 'here'
    > 03) );
    >
    > FWIW MyTable is a linked table in another A97 database.
    >
    > I reuse this query daily by pasting new values in the IN list on line 02
    > and immediately running it.
    >
    > Occasionally the results match {'paste', 'your', 'soups', 'here'} (i.e.,
    > the saved version of the query) rather than the new values I pasted only
    > moments before. When I switch to the SQL view, sure enough, my newly
    > pasted values are gone and the query has reverted to the saved version.
    > This happens sporadically, sometimes daily, other times maybe once a week.
    >
    > Has anyone seen this behavior?
    >
    > The work-around, which is simple enough, is to save the query with the new
    > values before running it. The only objection to doing this is it strips
    > the "instructions" for other users.
    >
    >
    > --
    > Smartin




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4197 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     
  4. Smartin

    Smartin
    Expand Collapse
    Guest

    Pieter Wijnen wrote:
    > a lot of times
    >
    > no help
    >
    > Pieter
    >
    > ps
    > usually making sure all objects are "killed" (ie set obj =nothing) +
    > repair, compact & decompile tends to ward it of - most times <g>
    >
    >
    > "Smartin" <smartin108@yahoo.com> wrote in message
    > news:8f6dnaL4tJMWFijZnZ2dnUVZ_s2dnZ2d@giganews.com...


    Interesting. Do you get this with linked tables, local tables, both?

    My setup is nothing fancy. One linked table, one query.

    Thanks for the feedback.

    --
    Smartin
     

Share This Page