
VB3 Err - Data Has Changed
Quote:
>Help... this is really starting to become a problem and is no longer isolated
>to VB3, I am getting it when I go into Access as well. The only cure is to
>restart windows. Even if there is no cure I sure would like to understand
>what causes this... then I could do what the good doctor says - "Stop doing
>that!"
>Me, again.
I have seen this happen when only part of a database record is corrupted, for e.g.
when a memo or ole field is corrupted but the index field is intact. We tried
repairing the db but it didn't seem to repair some memo or ole fields. I think this
happened to us because of bad drives in our file server. What he had to do was
browse the table in Access carefully until we hit the record that causes a "Data has
changed error." Usually you will be able to figure out which fields where damaged
and could possibly recover them from a backup.
I would repair the database first. If it happens again, then it could be a bad drive or
some network problem. Good luck.
--
-----------------
Floro Crisostomo