Setting up Multiple Databases

Top

 

The two databases that are activated at registration are your primary database and the Rental Demonstration database, which is used for training and testing.

To start with a database with basic account codes, pre-defined statement styles, and other setup basics, create a folder at the Drive Letter\Path (e.g. F:|RPROMAS) and copy the LL12_Database from the Data QuickStart folder into that folder. Then follow the startup directions.

 

Add an Additional Database

Select the System Security database on the Logon screen.

Enter the System Security password, established at registration.

Select Tab 4 – Database Directories.

Click the <New Database> button.

Leave the Database Class field blank.

Enter a Database Name

Enter the Data Path in one of the following formats

.foldername -- e.g. .myfolder (the period preceeding the folder name takes the place of the drive letter and the rpromas folder)

Drive Letter\Path\foldername -- e.g. F:\RPROMAS\MyFolder

If your license is for anything other than unlimited you can maintain up to three separate databases. An unlimited license lets you define an unlimited number of databases.

 

Multiple Databases

In general one database is sufficient for most users since multiple sets of books can be maintained within a single database. Instances where you might want to consider separate databases include:

Keeping self-owned properties separate from managed properties

Maintaining the company books

keeping the financial records for more than one association

processing responsibility (posting receipts, writing checks, etc) is functionally separate, i.e. bookkeeper 1 does all processing for one set and bookkeeper 2 does all processing for another set.

Limit Access to a Database

A user can be limited to specific databases by assigning a Database Class name to the database in System Security, Database Directories tab and then assigning the same Database Class to the user in System Security, Users tab.