I have an Access 2007 FE database that links to a SQL server 2005 with ODBC
linked tables.For most of the time the database works fine but every so
often things go screwy in one form.
The form uses a filtered record set in a continuous form view and allows
the
user to add and edit the records. This will be working fine for days and
then suddenly when someone is in the process of entering a new record and
at
the moment the record is saved the details of that record change. Instead
of
the new record being displayed a previous and apparently random record is
displayed. The displayed record won't even be in the selected filter set
and
the newly created record will not appear in the displayed records until
the
record set is refreshed.
This behaviour then occurs all the time. The only way I can stop this
behaviour is to cut all the records out of the table and then past them
back
in.
I have tried rebuilding the indexes but that changes nothing.
Does anybody have any ideas of what is causing it or how to stop it.
Thank you for any response.
Adam
