Data missing from table after editing data in a field

B

BeckyP

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.
 
J

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.
Click to expand...

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

BeckyP

Thank you. Will try this solution.

John Vinson said:
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]
Click to expand...
 
Top