NOTE: Before you begin the update, make sure all users are completely logged out of the system.  If there is anyone else logged in, the update will not work, and you will get error messages after you have updated. You can check if anyone is logged on by using the Current Users option on the System Maintenance menu. Don’t worry about any mdbdeveloper users, but all other users should be logged out.


Downloading the Latest Version of ChintaroSQL


Click this link to be taken to the solution for Updating Patch Instructions/ Downloading and Installing the Latest Version of Chintaro.


Once you have downloaded the SQL version of Chintaro.mdb, come back to this page.


Installing the CHINTAROSQL Client on a PC (or virtual desktop) 


The zip file you downloaded will contain 3 files:


The chintaroSQL.mdb file is the code database and the two ".sql" files are Microsoft SQL Server scripts that must be run before you launch Chintaro.


The ChintaroSQL client (chintaroSQL.mdb) will usually be installed on the local drive (usually C:\) of each PC that will be used to run Chintaro.
 

Once you have downloaded the zip file containing the chintaroSQL.mdb file, you should copy this file and paste it in the location of your existing version. This is often C:\ChintaroSQL but may not be. You can check the location by looking at the properties of the shortcut you usually use to launch Chintaro.

Do this by right-clicking on the shortcut icon and choosing properties. You will see the following screen:  




The location of the Client file in this example is “C:\CHINTAROSQL\chintarosql.mdb”


If you are using a remote desktop environment, it is important that each user has their own instance of chintaroSQL.mdb running. Usually, this is installed under the \Users\Folder structure, making use of the Username% parameter.



Running the scripts in the SQLServer Management Studio


Before you launch Chintaro, you must run the 2 scripts in the zip file in the SQL Server Management Studio (SSMS) . The 2 scripts (below) must be run in the order they are numbered:



NOTE: Ignore all error messages you receive when running the scripts. 


Once you have run these scripts, you can close SSMS and launch ChintaroSQL from the desktop shortcut. 



Launching the new version of ChintaroSQL


Log in to ChintaroSQL by double clicking the shortcut file using your normal login details. You will see the following logon box:


Enter your username and password. The first time you log into the new version of Chintaro, there will be a noticeable delay before the system starts. This is due to Chintaro making changes to the database, and shouldn’t take more than a few extra seconds. If this takes a long time, it will be due to another user being logged in. If you can get them to log out, it will speed up the process.


Once the system opens, check that Chintaro is now the latest version (under the CHINTARO logo on the Home Screen, named ChintaroSQL DATE).

Close Chintaro and copy the chintaroSQL.mdb file you just updated around to any other user’s PCs. You must use the copy you installed and updated (from the c:\chintaroSQL folder) rather than the one you downloaded.



Installing the chintaroSQL.mdb file on other PCs 


Once you have set-up the first client PC, simply copy the chintarosql.mdb file onto any other PC that uses Chintaro. You can use a memory stick, or copy it via your Shared Drive.