Databases for Healthcare Almanac

1. Download Databases.

The databases are 40 to 300 Megabytes in zipped format. You should have a DSL/High Speed internet connection to download these files. The files are zipped and encrypted with WinZip Version 20. When you unzip the database, you will be prompted for a password. You can obtain the password by calling Client Support at 561-594-7551.

Please create a directory with a name like "Halmanac" or "HDatabases" (any name will work) to save the downloaded files.

Click each button and select "Save" to download each database.

2. Unzip each database.

After the downloads are complete, unzip the files in the directory you created. When the files are unzipped, you will be prompted for a password. The password is available from Client Support at 561-594-7551. There will be two files for each database, one with an .mdf extension and the other with a .ldf extension

3. Attach each POS/UPIN Database.

Start the Healthcare Almanac software. Select the Databases menu item. Select the POS submenu item. Click the Connect button. The status window on the screen should show you are connected to SQL Server. Select a Database POS_2005 through POS_2015. Then click the Attach button. Navigate to the database file, highlight the database file and then click the Open button. This will attach the database for access by Healthcare Almanac.

4. Attach each CR Database.

Start the Healthcare Almanac software by selecting the item on the menubar. Select the Databases menu item. Select the CR menu item. Click the Connect button. The status window on the screen should show you are connected to SQL Server. Select a Database CR_2005 through CR_2017. Then click the Attach button. Navigate to the database file, highlight the database and then click the Open button. This will attach the database for access by Healthcare Almanac.

5. Attach the REF_ALL and UPIN_ALL Databases.

Start the Healthcare Almanac software by selecting the item on the menubar. Select the Databases menu item. Select the System menu item. Click the Connect button. The status window on the screen should show you are connected to SQL Server. Select the REF_ALL or UPIN_ALL databases. Then click the Attach button. Navigate to the database file, highlight the database and then click the Open button. This will attach the database for access by Healthcare Almanac.

6. Set the Access Mode to Local for the Databases

Start the Healthcare Almanac software by selecting the item on the menubar. Select the databases menu item. Select the Access menu item. Then select "Local" as the access method.