Local Database

The “Local Database” field defines the location of the local database. The mapped path in the below image shows its location as “C:\Program Files\CAS\Toxicall\ToxiLoc.mdb”. ToxiLoc.mdb is the recommended file name for the local database.

To update the Local Database location, click the 3-dot lookup button to the right of the “Local Database” field.

 

Note: By allowing users to work on their local database until connectivity is restored, TOXICALL® can continue to capture cases during a network failure.

 

* -- Compact/Repair: This will run a Compact and Repair on the respective database (one icon is next to network and the other is next to local database).

*            -- CopyToxiUser information to SQL: This is automates the process of copying system table information when switching from an Access database type to a SQL Server database type. Note: Be sure you back up your ToxiUser database before performing this process. This configuration can cause the loss of the source database file data.