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