HA Databases

If you can not install from the internet due to privacy, security or accessability reasons, we will send a set of DVDs. The first DVD is Software Installation and the second DVD is Database Installation. The DVD Installation is the same as the internet installation except you have DVDs. The DVDs will be sent from our office by Fedex or US Mail.

1. Load Installation DVDs to Local Disk Drive

Please create a directory ( we suggest the name - Halmanac) on your local hard drive. Copy the contents of the DVDs to the directory. The files will have filenames that clearly identify the contents of each file.

2. Prepare User Database

Use Windows Explorer and navigate to the installation directory (Halmanac). Click on the file named Provider.zip and expand the database in the directory. The User Database was created with WinZip 14.0.

3. Install Provider Almanac software and Microsoft Components

Use Windows Explorer and navigate to the installation directory (Halmanac). Click on the file named ProviderAlmanac.msi. Please follow the instructions on the screen. The software consists of the following items;

  • Provider Almanac software
  • Microsoft Framework 4.5 (from Microsoft Corporation)
  • SQL Server Compact 4.0 SP1 (from Microsoft Corporation).
  • Microsoft Report Viewer 2012 version (from Microsoft Corporation)

All of the software listed from Microsoft Corporation can be downloaded and installed from Microsoft websites. Provider Almanac is developed with Microsoft software and we are licensed for redistribution of these Microsoft components. If any of the Microsoft Components are already installed, the components will be bypassed or upgraded as necessary.

4. Locate User Database Message

Go to the start menu or desktop icon and select Provider Almanac. When the software begins, you may see a message to Locate the User Database. If so, select the menu iten File and User Database. Use the browse button and locate the user database in the Installation directory. Press close to save the location.

5. Prepare Provider Almanac User Database

Go to the start menu or desktop icon and select Provider Almanac. When the software begins, select the menu item File and then select Client Setup On this screen, enter the Client Name and Client Password. You received this information with the DVDs. Press the save button to save the information. This information is used as an SQL Login for the Permanent Databases. If you also received the Database DVD, then continue on to the next step.

6. Install Databases DVD.

Use Windows Explorer and navigate to the directory name Permanent Databases. You must unzip/expand each database zipped file. You should place the databases in the installation directory. These databases are not updated and therefore no backup is not necessary. You must kept these DVDs to restore the Permanent Database. A password is required to unzip the databases. Pease call Client Support at 561-594-7551 for assistance in attaching the Permanent Databases.

Go to the start menu and select Provider Almanac. When the software begins, select the menu item Database and then select POS Database or CR Database . You must complete these steps for each permanent database. On this screen, select the name of the database to want to attach. This will display the current verion of SQL Server Express and any attached databases. To attach the new Permanent Database, select the button Attach and navigate to the disk location of the Permanent Database. Then select Open for the highlighted database and the screen will close. The information list will show the new attached User Database.