Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $95

New records appear twice in table

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

  1. GHawkins

    GHawkins
    Expand Collapse
    Guest

    I have a user working with an Access front end (Access 2003, SP2) linked to
    SQL tables. From Access, the user opens the table, adds a record, closes the
    table and opens it again. The record she just added shows up two times. The
    record count on the table goes up one number (from 269 to 270), and when you
    query the table from SQL the record shows up just once. If we delete one of
    the duplicate items, close the table and reopen it, both of the records are
    removed. The record no longer exists in SQL, and the record count goes back
    to 269.

    She is editing the information directly to the table, not through a form.

    Has anyone seen this before? I assume it's a problem with Access, but can't
    find anything on it. Any help would be greatly appreciated - thanks in
    advance!
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Fri, 12 May 2006 08:46:02 -0700, GHawkins
    <GHawkins@discussions.microsoft.com> wrote:

    >I have a user working with an Access front end (Access 2003, SP2) linked to
    >SQL tables. From Access, the user opens the table, adds a record, closes the
    >table and opens it again. The record she just added shows up two times. The
    >record count on the table goes up one number (from 269 to 270), and when you
    >query the table from SQL the record shows up just once. If we delete one of
    >the duplicate items, close the table and reopen it, both of the records are
    >removed. The record no longer exists in SQL, and the record count goes back
    >to 269.


    It sounds to me like the user is (presumably unintentionally) viewing
    a Query instead of the Table, and that this query is doing a Cartesian
    join with two records. Is this in fact directly in the table
    datasheet? Does using the Linked Table Manager to refresh the links
    change anything?

    John W. Vinson[MVP]
     
  4. GHawkins

    GHawkins
    Expand Collapse
    Guest

    She is editing directly in the table. We refreshed the links, and it looks
    like that fixed it! Thanks for your help!

    "John Vinson" wrote:

    > On Fri, 12 May 2006 08:46:02 -0700, GHawkins
    > <GHawkins@discussions.microsoft.com> wrote:
    >
    > >I have a user working with an Access front end (Access 2003, SP2) linked to
    > >SQL tables. From Access, the user opens the table, adds a record, closes the
    > >table and opens it again. The record she just added shows up two times. The
    > >record count on the table goes up one number (from 269 to 270), and when you
    > >query the table from SQL the record shows up just once. If we delete one of
    > >the duplicate items, close the table and reopen it, both of the records are
    > >removed. The record no longer exists in SQL, and the record count goes back
    > >to 269.

    >
    > It sounds to me like the user is (presumably unintentionally) viewing
    > a Query instead of the Table, and that this query is doing a Cartesian
    > join with two records. Is this in fact directly in the table
    > datasheet? Does using the Linked Table Manager to refresh the links
    > change anything?
    >
    > John W. Vinson[MVP]
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page