I have a number of access databases with this fault. When a user enters a new record onto a form or table once the insert is applied to the table different record is displayed. The correct record is inserted into the table. This is very confusing for the users. If they close the form and open it again the correct data is displayed but same thing happens on next insert.
All the databases are developed in Access 2003 and could be either 2000 or 2003 format.
SQL Server 2005 hosts source database, this affects different databases only common thing is the same server and all use Merge replication. This fault occurs at the Publisher and all effected tables have Int Identity columns managed by replication.
I am using Simple ODBC linked tables using trusted connection
This effects Different client computers ie Windows XP, Vista, Citrix and Different user accounts ie Administrators and normal users affected.
Once a database is affected the only fix is to recreate the client front end from scratch and if lucky (1 chance out of 10) the fault goes away for a period of time. I have resorted to recreating the replicated (back end) databases a number of times and the fault disappears for a while but soon comes back.
I have attached 2 screen shots to demonstrate this. In this example the record was inserted into the table with an id of 136181.