Site5 - Built For Designers & Developers MENU

DBF error.The database cannot be open.

[2 Grey Star Level]

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?

Answer #1

Hello,

The database table may be corrupt. If you have a recent backup of it, try repairing the table in PHPMyAdmin, using the guide at http://kb.site5.com/control/phpmyadmin-control/phpmyadmin-how-to-repair-tables/

If you do not have a recent backup, make a backup of the database first 🙂

Answers Answered By: jdavey [359 Blue Star Level]

Answer #2

Do you know xBase (VFP) language?
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” .
Does the app folder contain some DLLs which could identify the program version?

Also check these links:
https://social.msdn.microsoft.com/Forums/en-US/3d459419-9e9b-4976-af55-b0e71268f535/lotus-notes-error?forum=officegeneral

https://www.repairtoolbox.com/dbfrepair.html

Answers Answered By: MathieuVag [2 Grey Star Level]

Answer #3

Hello Mathieu

Thank you for your input on this. I do not believe most of this will be necessary, but it is always good to have a different perspective 🙂

Answers Answered By: jdavey [359 Blue Star Level]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »

Money Back Guarantees
Click to verify BBB accreditation and to see a BBB report.