Strange disappearance of one field's values in a table

[BJM]

I have a database that I work on in both Access XP and 2K.

Somewhere along the line, the contents of one field in a
table has been lost.

Is it possible that the translation back and forth between
the two versions could result in such a thing?

The rest of the table data is fine but for some unkown
reason the contents of one field has just vanished!!!

I don't suppose I can get the data back without reentering
it, but I would obviously like to prevent this sort of
thing from happening again.

Thanks,
BJM

 

[John Nurick]

I have a database that I work on in both Access XP and 2K.

Somewhere along the line, the contents of one field in a
table has been lost.

Is it possible that the translation back and forth between
the two versions could result in such a thing?

Unlikely, although the Access file format conversion system (like most
others) isn't designed for continual back-and-forth conversions.
Normally, however, no translation between these two versions is needed:
by default, Access XP uses the Access 2000 file format.

The rest of the table data is fine but for some unkown
reason the contents of one field has just vanished!!!

It's possible that the data is still there but that it's formatted in a
way that hides it. Create a query with a calculated field like this
L: IIF(IsNull([X]),X,Len(Cstr(Nz([X]))))
where XXX is the name of the field. This will return Null if the field
is really empty (null) and otherwise the number of characters in the
field (or in a string representation of its contents).