Maintaining Database Profiles


Table of Contents   Previous Page  Next Page    

Database profiles tell MemberTies where to find a particular database, what to call it (the name that appears in the Database dropdown on the Login window), and what license should be used with it, if any.

Note: All profiles that are stored on your computer are available for editing. However, the license information can only be modified if you are connected to the database the license is assigned to.  If you log into one database and then open the profile for another, license information will not be available because the system cannot find the information from the other database.

Profiles can also be exported/imported for easy distribution. See Importing/Exporting Database Profiles for details.

Adding a Database Profile

1Open the New Database Profile window. This can happen in several ways:
From the Login Window, choose (Specify New…) from the database dropdown list.
From within MemberTies, choose Tools > Preferences, expand the Database section, choose Profiles, and click New.

 

2A new Database Profile has two major sections:

 Database Name - This is the brief "user friendly" name of the database which will appear in the Database dropdown on the Login window.  If your database is for your Skiing Club, a logical profile name would be, "Ski Club". The profile name is simply a convenience. If your database folder name is actually "mt_skiclub_aspen_division", a simple name like "Ski Club" is much nicer to see in the Database list.

 Database Folder - This section lets you specify the name or location of the database folder, which is where all the files that make up the database are stored.  Chose one of the following options:

Choose Existing Database - to identify an existing local or remote database
Create New Database - to create a new database. See Creating a New Database for details.
3If you click "Choose Existing Database", the Choose Database window will open:

 To specify a local database, select "Local Database (on this computer)", and then choose a database from the dropdown list of available databases.  This list contains all database on your computer to which the server has access.

 

 To specify a remote database, select "Remote Database (on another computer)", and then complete the fields to identify the database. If you're not sure what these fields are for, please see, Setting Up a Multi-User System database for details.

 

4After choosing or creating a database, you will return to the New Database Profile window, and the database folder will be displayed.

 If you are connecting to a database hosted by Myrro International, you will have received special Server Login credentials.  In this case click the Advanced button and enter the login information on the Advanced Profile Settings window.

 

 Note: Do NOT use these fields if you are running a local database server (i.e., a normal MemberTies installation with a database on your computer) or you will not be able to connect.  These settings are only for remote database profiles to servers requiring special connection parameters (such as our hosted database server).  These fields are not used for the normal user name and password information you put on the Login window when MemberTies  starts.

 The "Show" button will display the password in plain text so you can see what you're typing.

 After entering advanced options, click OK to return to the Database Profile window.

5When you are finished, click OK. The database information will be verified, and if applicable the license name and number will be validated. If everything is correct, the new profile will be added to the list of databases MemberTies knows about.

 Note: If you are adding a new profile from the Login window, clicking OK will return you to the login window and the database dropdown list will be updated with the new entry.

Changing a Database Profile

A database profile can be modified from within MemberTies, or from the Login window.

From the Login window:

1Select the database you want in the Database list.
2Right-click the Database field, and choose "Modify Database Profile" from the popup menu.

 

or from within MemberTies:

1Choose Tools > Preferences, expand the Database section, and choose Profiles.
2Select the database profile you want to change, then click Open.

On the Maintain Database Profile window...

The following fields are available:

Database Name - This is the name that displays in the Database list on the Login window.  Any short, simple name is good.

Database Folder - This is the actual location of the database. This field is filled-in for you when you choose an existing database or create a new one.

License Info for this Database -

 (These fields are only displayed if you are editing the active database profile from within MemberTies. )

 If you do not have a license, leave these fields blank and the database will function in "shareware mode," allowing a limited number of records but otherwise fully functional.

 You can also leave the license fields blank if you have just upgraded from an older version of MemberTies and your license is no longer valid.  You may not be allowed to enter new records until you upgrade your license, but your existing data will not be harmed or lost, and you'll be able to open records and see everything normally.

 Licensee - If you have an existing license, enter the licensee name exactly as it appears on your license.

 Number - If you have a license number, enter it exactly as it appears on your license.

 Easy License Entry: If you have an email containing the license information, it contains specific instructions about how to copy the license text from the email message so that it can be easily pasted into these fields all at once using the "Paste License" option.

Advanced

 If you are connecting to a database hosted by Myrro International, you will have received special Server Login credentials.  In this case click the Advanced button and enter the login information on the Advanced Profile Settings window.

 

 Note: Do NOT use these fields if you are running a local database server (i.e., a normal MemberTies installation with a database on your computer) or you will not be able to connect.  These settings are only for remote database profiles to servers requiring special connection parameters (such as our hosted database server).  These fields are not used for the normal user name and password information you put on the Login window when MemberTies  starts.

 The "Show" button will display the password in plain text so you can see what you're typing.  For security reasons, if you accessed this window from the login window rather than from within MemberTies, any existing password will be cleared first before the field is changed to plain text. Otherwise, anyone could go to the login window, edit your profile, and see your password.

 After entering advanced options, click OK to return to the Database Profile window.

Deleting a Database Profile

Deleting a database profile has NO EFFECT on the actual database or its current or backup directory. It simply removes details in the database profile.  To physically delete the database follow the instructions under Deleting a Database.  If you do not delete the physical database itself, a new empty profile will be created for it the next time you log in, because MemberTies will see that a database exists.

1Choose Tools > Preferences, expand the Database section, and choose Profiles.
2Select the database profile you want to delete, then click Delete.