How to set up a new database

How to set up a new database

Applies to: That's Rights!, That's Rights Agents and EasyRoyalties
When using these applications, your data is stored in a database file, which can be managed independently of the application installed on each user’s PC.

When first installing the software, a demonstration database is initialised and presented to the user. The default location for the demo database is the \data folder in the directory where That’s Rights! is installed. For example, for That's Rights! this will typically be:
C:\Program files (x86)\JDC Software\Thats Rights v4\data\
The default database filename is “trdata.dat”

You can continue to use this database, or initialise another database (with or without demonstration data).

Creating new databases

To create a new database, go to Preferences > Connection management > Change database..., select "New database", then click "Browse..." and select a name and location for your new database file.


Database location

The database does not have to reside in the default location used by the application’s demo database. The database can be placed in any location, as long as it is located in the same local area network as the application software.

For multi-user configurations, you can place the database file on a shared disc or fileserver. No special software is required, however any user who will be connecting their copy of That’s Rights!/EasyRoyalties to the database must have read/write access to the location where the database is located.

Remote access from outside the local area network does not work effectively, and is not recommended as it can result in damage to the database. For remote access requirements, the recommended solution is to set up a terminal server and provide access to remote users via remote windows desktop. (Special installation procedures apply to the application software in a terminal server environment; contact support@thatsrights.com for more information.)

    • Related Articles

    • I'm getting a message that my database is corrupt

      If your software stops or cannot be launched and gives you an error message that your database is corrupt, you will need to send us your database file for us to examine and repair (if possible). You can send us your zipped database file via ...

    • How do I send my database to Support?

      To send your database (along with supporting files such as error logs and settings files): 1. Go to Options & settings > Database management and click "Package files for support" 2. Select the items to include (database, error log, settings file, ...

    • Backing up your database (and back-up reminders)

      Your database is a file separate from That's Rights! or EasyRoyalties software; it sits on your device or any external server on the same LAN. To avoid losing any data, your database file should be backed up periodically with any back-up system you ...

    • How do I connect to the new database that was returned to me from Support?

      If we have sent you a database for you to use with your copy of the software, follow the steps below to connect to the new database: If you have an existing database file, you may wish to make a copy of it before proceeding. This will allow you to ...

    • How do I initialise a new database without demonstration data?

      Initialising a new database Applies to: That's Rights!, That's Rights Agents, EasyRoyalties To create a new database without the sample demonstration data, perform the following actions: 1. Go to Preferences > Connection management > Change database ...