Section 2:
Getting Started
Section Contents
Quick Start PAGEREF _Toc186854871 \h 45
Essential Program Configuration 45
Optimizing the Program for Speed 45
Optimizing Hardware for Speed 46
Optimizing a Network for Speed 46
Optimizing Program Options for Speed 47
Optimizing the Database for Speed 48
Accepting the License Agreement 48
Choosing Between Editions that use Microsoft Access versus SQL Databases 50
Working with Microsoft Access Databases 51
Creating a New Empty Access Database 51
Opening an Existing Access Database 52
Updating the Access Database Structure after a Program Upgrade 53
Saving a Backup Copy of an Access Database 54
Saving a Zipped Backup Copy of an Access Database 54
Automatically Backing Up an Access Database 55
Restoring a Database Backup 57
Repairing and Compacting an Access Database 57
Archiving an Access Database 58
Working With MySQL Databases 60
Creating a New Empty MySQL Database 60
Importing an Access Database to a New MySQL Database 62
Opening an Existing MySQL Database 63
Updating the MySQL Database Structure after a Program Upgrade 64
Saving a Backup Copy of a MySQL Database 65
Saving a Zipped Backup Copy of a MySQL Database 65
Moving a MySQL Database to a Different Server 66
MySQL Database Administration 66
Working With Microsoft SQL Server Databases 67
Creating a New Empty Microsoft SQL Server Database 67
Importing an Access Database to a New Microsoft SQL Server Database 68
Opening an Existing Microsoft SQL Server Database 70
Updating the Microsoft SQL Server Database Structure after a Program Upgrade 72
Closing a Microsoft SQL Server Database 73
Saving a Backup Copy of a Microsoft SQL Server Database 73
Saving a Zipped Backup Copy of a Microsoft SQL Server Database 73
Moving a Microsoft SQL Server Database to a Different Server 74
Repairing a Microsoft SQL Server Database 74
Microsoft SQL Server Database Administration 74
Working With Mobile Edition Databases 75
Configuring a Master Database for Mobile Workstations 75
Configuring a Mobile Workstation 76
Synchronizing a Mobile Edition Database 77
Configuring User Security on Microsoft SQL Server 81
User Security Listing Reports 83
Browsing the User Edit History 84
User Edit History Group Filters 85
Working with the User Edit History 85
Activating/Deactivating User Edit History Logging 85
Clearing the User Edit History 85
Recording History in Multi-Line Text Fields 85
Working with Microsoft Access Databases
Working With Microsoft SQL Server Databases