Upgrading Data Files

This procedure requires exclusive use of the data files. This means that all other users on your network must exit the point of sale system before you begin. To see which computers are currently in the point of sale, go to Help User List from the main menu where you will see the list of computers currently logged in. The only computer that should be logged in should be the one you are at.

Whenever you need to remove deleted records or re-generate file indexes, you need to run Table Manager. From the Main Menu, select File Table Manager. You will have the following options.

Upgrade All Files

This will upgrade your datafiles, remove any records marked for deletion, and create new indexes. Select File Table Manager Upgrade All Files from the Main Menu. You will be asked to confirm that you want to proceed. Select Yes to proceed or No to cancel. If you are on a network, it is quicker to run this directly from your server rather than a workstation. This will upgrade all of the shared datafiles as well as the local files on the workstation where you are running it from.

To Upgrade a Single File

This will upgrade, remove any records marked for deletion and create new indexes for a single file only. Select File Table Manager Rebuild Single File from the Main Menu. A list of your data files will appear.

Scroll down the list and highlight the file you want to upgrade and select Ok.

To Upgrade Local Files

This will upgrade, remove any records marked for deletion and create new indexes for the datafiles stored on this workstation only. Select File Table Manager Upgrade Local Files Only from the Main Menu and select Ok.

To recreate your indexes without removing and deleted records, see Reindexing Data Files.