Data missing from table after editing data in a field

[Guest]

I corrected some data in one field in my database and now the entire record
is missing. Has anyone ever had this happen before? What causes this and
how can it be fixed. The record displays as blank fields, including the key
field, but am unable to enter/edit the fields. Keep getting error messages
that read "The search key was not found in any record" then "You can't save
the record at this time..." or "Record is too large" or the data I enter just
disappears. Any help would be appreciated. Of course, as usual, I am on a
deadline when this happens.

 

[John Vinson]

I corrected some data in one field in my database and now the entire record
is missing. Has anyone ever had this happen before? What causes this and
how can it be fixed. The record displays as blank fields, including the key
field, but am unable to enter/edit the fields. Keep getting error messages
that read "The search key was not found in any record" then "You can't save
the record at this time..." or "Record is too large" or the data I enter just
disappears. Any help would be appreciated. Of course, as usual, I am on a
deadline when this happens.

Does this effect appear on a Form, or actually in the table datasheet?
If it's a Form, the query upon which the form is based may be at
fault. If it's the table... your database is corrupt and may or may
not be recoverable. Try Tools... Database Utilities... Compact and
Repair database, AFTER YOU HAVE MADE AND TESTED A BACKUP.

John W. Vinson[MVP]

 

[Guest]

Thank you. Will try this solution.

Does this effect appear on a Form, or actually in the table datasheet?
If it's a Form, the query upon which the form is based may be at
fault. If it's the table... your database is corrupt and may or may
not be recoverable. Try Tools... Database Utilities... Compact and
Repair database, AFTER YOU HAVE MADE AND TESTED A BACKUP.

John W. Vinson[MVP]