Error Not A Valid Integer/Error Access Violation
These error messages indicate various types of corruption within your data set. This corruption could range from a single record, to large portions of the data file. If the data is returning an Access Violation error in address “FFFFFFFF” or “00000000”, the error is the result of data corruption. If any other address is returned, the error is not data related. You would need to look at the Medisoft program, your Windows environment, your network, etc.
Tools Needed
Advantage Data Architect (ARC32)
Process for Correcting
1. Identify which data files are corrupt and giving you the error message.
2. Open the corrupted table using ARC32. (Refer to Appendix A for information on how to do this.)
3. Open the Table Designer window by clicking Table and Properties.
4. Identify which fields have the type “Integer”. Information on how to do this is located in Appendix D.
5. Close Table Designer.
6. Scroll through the table, and locate the value that is not a valid integer. You will need to either delete records that have the invalid value, or change the value to a valid entry.
7. If you are having problems identifying which record has the invalid data, you may want to look at the ADS_ERR.DBF file. This file is located directly in the root of c:\. If you have ARC32 installed, you should be able to simply double-click on the file, and it will open in ARC32.
8. You will see a log of all instances where an Advantage Error occurred on that machine. You will see the Error Code, File Name, and Source Line. The source line will be the line number within ARC32 where you can find the data that is causing the error message.