Welcome to SPN

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

Sign Up Now!

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

Share This Page