Switching Databases

<< <%SKIN-STRTRANS-SYNTOC%> >>

Navigation:  DATABASE MAINTENANCE >

Switching Databases

You can have multiple accounting databases for multiple organizations in ACCOUNTS.

 

This is managed with a standard document-based metaphor, as in a word processing program. Each database is given a base filename, ending with ".S4A" (which stands for Software4nonprofits Accounts). The base filename is specified in the Maintenance Organization Info window.

 

You create a new database for a new organization with the File New Database menu option. You can also use that option to restore a regular, email or Internet backup database from another organization or another computer. Choosing that menu option takes you to the Startup Options window.

 

You switch to a different database that you have created with the File Open Database menu option.

 

Each database must be backed up independently, when it is open, with the Backup/Restore menu options.

 

Note on Multiple Databases and License Keys

 

The software licensing in ACCOUNTS is by Organization Name. So, if you already have a license key for ACCOUNTS, and you create a new database for a new organization with a different Organization Name, that database will temporarily no longer be licensed and ACCOUNTS will go back to being an Evaluation version when you are using it. You will have to request another license key. To make this request immediately, you can either exit and restart ACCOUNTS, which will bring up the Evaluation and Licensing window, or use Tools Request or Install License Key which will also bring it up.

 

As long as you have paid for ACCOUNTS in the last 12 months, there will normally be no charge for additional license keys for additional organizations. Just request it and we will send it to you. The only exception is if you have more than 5 different databases, in which case we will ask you to pay to upgrade to the Network Version. You don't have to actually switch to and use that version - it is just a convenient higher price that we charge to account for our additional administrative time giving multiple license keys, and the additional value you derive from being able to use ACCOUNTS for so many organizations.

 

Users who are still in their initial evaluation period do not have or need license keys, so this is not an issue until you purchase the program, at which point you will need to request license keys for each of your databases.

 

Memorized Reports and Switching Databases

 

Starting in version 1.28 of ACCOUNTS, memorized reports are stored in the database. Previously they used to be stored in separate files in the Report subdirectory under the data directory of the program. One implication of this change is that whereas all memorized reports used to be shared by all of your databases, they are now specific to each database. In some cases this will be exactly what you want, while in other cases you will want to share them between multiple databases.

 

If you want the same memorized report to be present in more than one database, you will have to create and memorize it in each of the databases.

 

Passwords and Multiple Databases

 

Any passwords that you set up or use in the program are only for your current database. Each database can have its own passwords.