Database path settings

The factory default database path settings are as shown in the figure below.

 Windows XP
C:\Program Files\Chirosoft\Data\Chirosoft.mdw

Windows Vista
C:\Users\Public\Documents\Chirosoft\Data\Chirosoft.mdw

If you are not able to logon to MyEMR for Windows, you should check the settings in Database32.

You can access Database32 from the Start menu, by selecting:

    Start->All Programs->Software Motif->Database32

If your database settings are not correct, you may get two errors loading Database32, so you should click through the two errors.

In this figure, note that the third tab, i.e., the "location" tab is selected.

Sharing the MyEMR for Windows files over a network.

1.    On the server, create a "share" on the C:\Program Files\Chirosoft (C:\Users\Public\Documents\Chirosoft for Vista) folder, called "CHIROSOFT".  Please note that this share must provide adequate network read/write/execute permissions to all intended users of MyEMR for Windows.

2.    Now make changes to each networked workstation.  Using the example that your server is named "SERVER", change the "Public Workgroup file" to be named "\\SERVER\CHIROSOFT\Data\Chirosoft.mdw".  This should be done by using the "..." button to browse your network for the server and its available "shares".  Your server network name is probably not "SERVER".  Your server name can be found by browsing your network or in the Control Panel under the System category and Computer Name or Network ID, depending or  your operating system.

3.    Never use networked drive letter mappings for these settings.  If the hard disk is not local, you must use the UNC network naming convention, as in "\\SERVER\CHIROSOFT\Data\Chirosoft.mdw".   

When installing an upgrade, and the database will not upgrade automatically:

1. From "My Computer", browse to the location of your cs_pub.mdb file.  The factory default location for this file is the C:\Program Files\Chirosoft\Data\Main folder.  For Windows Vista, the factory default location is the C:\Users\Public\Public Documents\Chirosoft\Data\Main.
2. Double-click on the DBRebuild.exe file.
3. Click "Begin".  The upgrade may take a few seconds to a few minutes.
4. When complete, you will receive the message "Database upgrade complete and renamed."
5. If you receive a message other than a successful message, immediately contact support@softwaremotif.com to open an eTicket.

Rebuilding or manually upgrading a database The database maintenance tools (for rebuilding a database or manually upgrading) are distributed with EMR Datacenter and MyEMR for Windows. These maintenance tools are located in the factory default location of:    C:\Program Files\Chirosoft\DBRebuild To rebuild or manually upgrade a database follow these steps: Identify the SQL design of your database prior to upgrading it by going to Start->All Programs->Software Motif->Database32.  Click the Version tab and note the Public number.  It will be a number such as 9.0.286*.  Make a note of this number.  This is the current database SQL design. Browse to the C:\Program Files\Chirosoft\DBRebuild folder Right-click over the blank database template in this folder which matches the current database design prior to upgrade, for example BLANK90286.mdb*, and choose copy from the menu. Browse to the C:\Program Files\Chirosoft\Data\Main folder (or otherwise desired site folder).  While in that folder, right-click and choose paste.

Figure 1

Now you are ready to rebuild the cs_pub.mdb data into the new BLANK90286.mdb* template. Browse back to the C:\Program Files\Chirosoft\DBRebuild folder.  Double-click on the file named DBRebuild.exe.  You will see a program appear as in Figure 1. Use the browse buttons as indicated by the bright blue arrows.  Browse to the file names indicated for the "Source Database" and "Target Database". Press the Begin button. The upgrade process will run.  You will receive two "Error 3666" messages, which are expected and can be ignored.  You should not get a third error message of any kind. You will receive a message of Rebuild Complete. Browse to the C:\Program Files\Chirosoft\Data\Main folder. Rename the current cs_pub.mdb file to another name, such as cs_pubSAVE.mdb. Rename the rebuild template, such as BLANK90286.mdb* to cs_pub.mdb, which is your new rebuilt database. Note:  Different versions of MyEMR for Windows and EMR Datacenter may distribute blank databases that are different versions.  You should always rebuild your existing database into the template installed in:      C:\Program Files\Chirosoft\DBRebuild.   * For purposes of this example, we'll use the SQL design of 9.0.286.

Backing up EMR Datacenter and/or MyEMR for Windows:

1.  From the menu of either EMR Datacenter or MyEMR for Windows, choose:

     Help->Backups

2.  You will be presented with a dialog box as in the figure below.  Note:  This figure indicates *your* backup folder and the folder in the figure below is only a sample.  This indicates that path that you want to backup.

3.  If you have further questions about this article, please contact support@softwaremotif.com.  Thank you!