DBF error.The database cannot be open.

SpirAv

Hello.
I have a software call Kodak Trophy(database program).This program stores patient data with x-rays. Now it is giving an error saying that the database cannot be open. When I try to reindex a codebase error appears with the following error Error #:-210, Error #:94003.
Unrecognized or Invalid Field Name EXT NUM
I have no idea how to fix this error.
Any ideas?

allan

Sounds like you might want to ask in a forum dedicated to your database software. Your question sounds like it is outside the scope of DataTables.

Allan

WWalsh

Do you know xBase (VFP) language?
Do you have Visual FoxPro available?
Do you have some older data backup?
Does your data folder contain more files than patients.* ?

If you don't know the language then you probably cannot fix the database and check all possible dependences.
The DBF version is stored in the first byte of the physical file. You may use some hexa editor to read it.
If you don't have VFP then you may download the VFP Run-time and some free restricted VFP version.
If you don't have data backup then you have to use whatever is available but data integrity isn't guaranteed in such case and other possible files will not be synchronised with your repared file probably.

The error message is also not clear. There is a difference between "database" and "table" in FoxPro. I am even not sure if the FoxPro is used as the development tool for the Kodak Trophy software. Neither 210 nor 94003 error exists in FoxPro core error set. The CDX file deletion isn't obvious operation

Does the app folder contain some DLLs which could identify the program version?

BTW, what is the total size of three patients files? u could fix it remotely.
Also visit this forum...read comments http://www.filerepairforum.com/forum/databases/databases-aa/dbase-iv-clipper-foxpro/687-how-to-repair-dbf-file

allan

This is not a general programming discussion forum, but rather one for DataTables. As such I'm going to close this discussion.