Database corruption is not uncommon with Access databases that are handling a lot of transactions. It can occur with either Access or SQL databases, but we have found that sites with high call volumes that run the network database on Access, have database corruption issues more frequently. There are other causes for this as well. For more information, please visit Microsoft online at www.microsoft.com. This document will discuss how to fix Access databases. Repairing SQL databases is the realm of the database administrator and beyond the scope of this manual. Running a repair/compact on the network database will generally resolve these issues.
If you have a corrupt database, follow the steps below:
•In TOXICALL®, choose the Tools menu, and then select Repair and Compact. You can also access this option through the Configuration window—just click the rounded arrow next to either the network or local database (whichever is corrupt).
•If this does not work, find a machine on your network that has Access97 installed and open it. Next, go to the Tools menu, then to Database Utilities, then select Repair. You will need to direct it to your database that is corrupt (usually the network—toxinet.mdb). When the repair completes successfully, go back to Tools/Database Utilities and select Compact. Again, select the appropriate database. It will ask you what file you would like to compact it into, usually it offers db1 as a suggested name. Write down the name and make sure you put the file in the same directory as the corrupted database.
•When this completes successfully, go to Windows Explorer, go to the directory where the corrupt database and newly repaired and compacted database are located. Right click on the corrupted database and choose Rename. Change the name to include something like ‘Bad’, or ‘Old’ to designate that it is corrupted. Next, find the fixed database. Right click it and choose Rename. Change this name to the name of the old database, for example - toxinet.mdb.
•Close these windows and start TOXICALL®, checking that you do not get the same errors as before. If any of these steps did not work, please contact TOXICALL® Technical Support for assistance.