Database Configuration

Database Location

When installing LHC Secure, you must decide whether to keep the LHC database on the local computer or move it to a shared network computer. Your choice depends on your lab's workflow:

Local — If one computer is used to control Agilent liquid handler(s), keep the database on this computer.
Network — If multiple computers are used to control Agilent liquid handler(s), put the database on a network that all LHC users can access.

By default during installation, the LHC stores the database on each computer (i.e., local), in the Windows Common Application Data Folder .

Learn more About the LHC Secure Databases.

Backups: A regular backup routine to safeguard the database records is recommended. This "Change Location" tool may also be necessary if you need to restore a database.

Database Optimization

The Optimize feature is part of the database clean up procedure. It executes the LHC's corruption-repair and size-compacting functions (when records have been marked for deletion during audit trail archiving) to reduce the database size.

Before "optimizing" the database, make sure all users are logged off the system.

Troubleshooting

When launched, the LHC attempts to connect to the database. If errors occur:

Make sure you are properly connected to your network, if applicable: cables are installed and the network server is live.
Quit the LHC and use Windows Explorer to verify the location of the database. A copy of the LHC_DB_ACC.mdb must reside in the specified location. Restore a backup version of the database, if necessary, or recopy the original database file to the expected location. Unfortunately, in these scenarios, any audit trail records logged, or users and settings defined since the file was saved are lost.
Contact Technical Support for further assistance.