>The fields in table ...dbf did not match the entries in the database.
>
>What does this mean and how can it happen and be prevented?
When you create a table in a database, information on the fields is stored not only in the table (DBF) but also in the database.
The error appears when copying a different version (structure) of the table to the database (that is, usually, to the folder that contains your data).
To avoid the error, keep table and database together - don't copy them separately.
As a quick fix, perhaps you can free the table (FREE TABLE). This will lose some information, like long field names.
You might also be able to recover the correct version of the table, ZAP it, and use APPEND FROM, from the wrong version.
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)