New records appear twice in table

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

 

[John Vinson]

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]

 

[Guest]

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