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
Accepting the License Agreement 52
Choosing Between Editions that use Microsoft Access versus SQL Databases 54
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
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
Restoring a Database Backup 61
Repairing and Compacting an Access Database 62
Archiving an Access Database 62
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
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
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
Configuring a Master Database for Mobile Workstations 80
Configuring a Mobile Workstation 81
Synchronizing a Mobile Edition Database 81
Configuring User Security on Microsoft SQL Server 86
User Security Listing Reports 88
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:
Working with Microsoft Access Databases
Working With Microsoft SQL Server Databases