This has 252 fields, and 75 start with "period_"
Not a pretty site to look at.
I have put this into a new database without other tables and still get the error.
Thank you for the thought
Tracy
>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
Tracy