Section 2:
Getting Started

Section Contents

Quick Start PAGEREF _Toc271291247 \h 49

Essential Program Configuration  49

Optimizing the Program for Speed  49

Optimizing Hardware for Speed  50

Optimizing a Network for Speed  50

Optimizing Program Options for Speed  51

Optimizing the Database for Speed  52

Running the Program   52

Starting the Program  52

Accepting the License Agreement 52

Evaluating Editions 53

Choosing Between Editions that use Microsoft Access versus SQL Databases 54

Logging In and Out 55

Exiting the Program  55

Working with Microsoft Access Databases  56

Creating a New Empty Access Database  56

Opening an Existing Access Database  56

Updating the Access Database Structure after a Program Upgrade  58

Closing an Access Database  58

Saving a Backup Copy of an Access Database  58

Saving a Zipped Backup Copy of an Access Database  59

Automatically Backing Up an Access Database  59

Backup Verification  61

Restoring a Database Backup  61

Repairing and Compacting an Access Database  62

Archiving an Access Database  62

Reporting on Archived Data  65

Working With MySQL Databases  65

Creating a New Empty MySQL Database  65

Importing an Access Database to a New MySQL Database  66

Opening an Existing MySQL Database  68

Updating the MySQL Database Structure after a Program Upgrade  69

Closing a MySQL Database  69

Saving a Backup Copy of a MySQL Database  69

Saving a Zipped Backup Copy of a MySQL Database  70

Moving a MySQL Database to a Different Server 70

Repairing a MySQL Database  71

MySQL Database Administration  71

Working With Microsoft SQL Server Databases  71

Creating a New Empty Microsoft SQL Server Database  71

Importing an Access Database to a New Microsoft SQL Server Database  73

Opening an Existing Microsoft SQL Server Database  75

Updating the Microsoft SQL Server Database Structure after a Program Upgrade  77

Closing a Microsoft SQL Server Database  77

Saving a Backup Copy of a Microsoft SQL Server Database  77

Saving a Zipped Backup Copy of a Microsoft SQL Server Database  78

Moving a Microsoft SQL Server Database to a Different Server 79

Repairing a Microsoft SQL Server Database  79

Microsoft SQL Server Database Administration  79

Working With Mobile Edition Databases  79

Mobile Edition Overview  79

Configuring a Master Database for Mobile Workstations 80

Configuring a Mobile Workstation  81

Synchronizing a Mobile Edition Database  81

User Security  84

User Security Overview  84

Browsing Users 84

Adding a New User 85

Editing a User 85

Deleting a User 85

Editing Users 85

Working With Users 86

Configuring User Security on Microsoft SQL Server 86

Changing a Password  88

Viewing Logged-In Users 88

Reporting on User Security  88

User Security Listing Reports 88

User Edit History  89

User Edit History Overview  89

Browsing the User Edit History  89

User Edit History Group Filters 90

Working with the User Edit History  90

Activating/Deactivating User Edit History Logging  90

Clearing the User Edit History  90

Recording History in Multi-Line Text Fields 90

 

More:

Quick Start

Running the Program

Working with Microsoft Access Databases

Working With MySQL Databases

Working With Microsoft SQL Server Databases

Working With Mobile Edition Databases

User Security

User Edit History