Have you tried: FREET TABLE?
After you freed the table add it again to your DBC

Peter


>The Validate Database wants me to delete the table.
>I have looked through the database via use db.dbc and verified each field exist in both table and dbc.
>
>I have been able to recreate this problem by creating this table from an ODBC table 3 different ways. copy to, copy structure to, afields - create table with array.
>
>Thank you for the quick responce.
>
>Tracy
>
>
>>VFP Help file gives you several pointers. Have you tried them?
>>
>>From VFP Help file:
>>
>>The fields in table "name" did not match the entries in the database (Error 1984)
>>When opening a database-owned table, Visual FoxPro tries to confirm that each field of the table has a matching field object in the database.
>>
>>The database or the table has been corrupted.
>>Use VALIDATE DATABASE to identify the problem.
>>
>>The table being opened is the wrong one.
>>Remove and re-add the table to the database.
>>
>>
>>>I have created a table in a database.
>>>If the database is closed I can open and use the table without an error.
>>>If the database is opened I get Error 1984.
>>>
>>>Does anyone know where I should go to start investigating this error?
>>>
>>>Tracy