Database Setup
Install new database or clear the demo database
Networked scenarios
We recommend installing a MySQL database on a central server. We made the installation straight forward and no technical knowledge is required. Follow the steps at Installing MySQL in the network to do the installation. More information on the topic you can find in Databases
Solo scenarios or Low Volume
Solo scenarios with a single computer and low volume of records can use the MSAccess database that comes by default with the program. You can clear out the demo content of the database from Tools-> Delete All Records in the ribbon
Change database password
We recommend changing the default database password to prevent unauthorized access to the records. Use the Database Password command under Tools to accomplish this.
|
Use with caution. All the computers that use the old password will need to be reconfigured to the new one |
Change admin user password
The admin user is a system user that has full privileges in the program. By default it has no password and to prevent unauthorized access into the program we recommend the change of his password. On how to change a user's password read How to change a user's password
Connect network workstations
You can connect other computers in the network to your database. For MySQL database the step are available at Installing MySQL in the network
For multiple physical locations, you can access the same database through the Internet. The step are available at Connect over the Internet
Backup strategy
You can easily backups your database using the Backup or Schedule Backup command.
We recommend you make regular backups once a week and take copies of the backups to another locations
Related
Installing MySQL in the network