The error occurs under the following:
Long field names are not unique within the first 10 characters
Table is opened through database reference

Work arounds:
1) Make sure field names are unique within the first 10 characters
2) Open table through path reference

My curiousity is asking:
If I use work around 2, am I going to run into more problems with my data?

Thank you for your input.

Tracy


>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