Click here to Skip to main content
15,867,686 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
We have a software call Kodak Trophy. It is a dental database program. This program stores patient data with x-rays. Now it is giving an error saying that the database cannot be open. I have copied 3 main files call patients.dbf, patients.cdx and patients.fpt and added it to the folder. It started working but soon found that the patients.cdx file disappears from the folder and the error saying that the dbf and cdx files cannot be opened. 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 solved this error
Posted
Comments
Richard MacCutchan 17-Sep-15 8:01am    
Call the support line for the product in question. This is not a programming issue.
Patrice T 17-Sep-15 8:13am    
Which dBase ? or dBase compiler ?
Do you have an "interactive prompt" ?

Well, you're not going to solve it here. Contact the vendor support for the application.
 
Share this answer
 
Comments
Patrice T 23-Sep-15 17:03pm    
xBase family languages have been at fame a while ago, and some CP members still remember. You certainly know "Visual FoxPro" at least by name.
patients.cdx is probably corrupted to the point it can't be repaired with REINDEX.

One possibility is to find even a very old patients.cdx file copy it with the other data files and REINDEX.

Otherwise, one need to reconstruct the cdx file but you have to know the formula and the compiler used.

Did you tried to contact the vendor ?
 
Share this answer
 
v2
Perform these actions to resolve this issue, otherwise I would offer you following topics, last one solution only for hardly crashed .dbf files

http://www.idganswers.com/question/14773/how-to-fix-dbf-file-error-missing-the-support-library
http://itknowledgeexchange.techtarget.com/itanswers/corrupt-dbf-files/
https://www.openfiletool.com/dbfopen.html DBF Open File Tool

You need to create an environment under which the table is NOT validated when it is opened. This can be achieved by the command -SET TABLEVALIDATE TO 0. Now you can easily open your tables.

These are some “Prevention Steps” to prevent your data from corruption:

Try to put a code in your program that automatically creates a duplicate copy of your tables (columns & rows), index files and databases.
Set-up a back-up routine.
Inform the user to properly shutdown the computer and regularly perform back-up.
Use UPS for power back-up.
 
Share this answer
 
Comments
Patrice T 23-Sep-15 17:04pm    
useless, requester don't have source code.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900