Choose the right Database

Depending on the number of network computers and volume of records you want to store, the following are our recommendations on choosing the database system:

1. Single Computer with Low Volume of records and No Images

To cover this case, Microsoft Access databases are sufficient. The Patient Manager applications come with a ready to use Microsoft Access database, so this is the out of the box solution.

2. Single Computer with Low Volume of Images

In this case we recommend the use of MSDE free database system. Note that this database system is limited to 2GB storage volume.

MSDE databases install by default with network availability disabled. Read how to install MSDE ready for network use.

3. Multiple Computers with Low Volume of records and Low Volume of Images

In this case we also recommend the use of MSDE free database system. Also note that this database system is limited to 2GB storage volume.

4. Multiple Computers with High Volume of records and/or High Volume of Images

For this networked scenario we recommend the use of either Microsoft SQL Server or MySql database. Here you the have best performance and virtually unlimited storage space for your medical records.

For MySql databases, after installation you must Extend the max_allowed_packet variable.

Related Articles

How to obtain and install Microsoft MSDE and How to install MSDE ready for network use

How to install Microsoft SQL Server

How to install MySQL on Windows and Extend the max_allowed_packet variable

Databases Overview

Database Usage Scenarios

Upgrade from Access Database

Top of Page

Using Patient Manager

Getting Started

Medical

Office

Administration

Choose the right Database