Database Management

This help file applies to an out-of-date version of MainBoss.
The most recent version of MainBoss is MainBoss 4.2.4.
For the latest version of this help file can be found here.

< Previous section | Table of Contents | Index | Next section >

MainBoss maintains a history of major changes to your database. These include:

The creation of the database
Importing data from MainBoss Basic (if applicable)
Upgrading to a new version of the database
Backups and restores performed through MainBoss (but not ones done entirely through SQL Server)

To see your current database history, use Administration | Database Management. The table viewer window displays the following:

Entry Date: Click this heading to sort the list by the date on which the change occurred. Click again to reverse the order (from ascending to descending or vice versa).

Subject: Click this heading to sort the list by the nature of the change. Click again to reverse the order.

Apply Filter: Lets you set up a filter to select which records should be shown in the table. For more information, see Table Filters.

Update Database Statistics: Asks SQL Server to update the information that is shown in the table viewer. This may be useful if you have received some unusual error message, e.g. a timeout when waiting for a report to print. The SQL Server information may give a hint about what's going wrong.

Print : Opens a window to print your database history. For more, see Printing Your Database Management Information.

Search : Lets you search through the list of records for a particular record. For more information, see Searching for a Particular Record. The Search button has an accompanying drop-down list containing the following:

Find Next: Uses the same search condition(s) as your most recent search and finds the next record in the table that matches the condition(s). If the search reaches the end of the table without finding a matching record, it goes to the start of the table and continues the search.

Find Previous: Same as Find Next except that it goes backward in the table. If the search reaches the start of the table without finding a matching record, it goes to the end of the table and continues the search.

Refresh : Updates the list to reflect any recent changes.

Close: Closes the window.

For general information on table viewers, see Using Table Viewers.