IF YOU ARE A CLOUD USER YOU DO NOT NEED TO UPDATE, CHINTARO SUPPORT DO THIS FOR YOU.


Download the latest Chintaro version from this link: ChintaroSQLx 2019.02.13 (13 February 2019) . The link will open up to our Dropbox account on your web browser. Click Download to start downloading the file.


These instructions are for updating Chintaro if you are a SQL user. If you are unsure which version of Chintaro you are running and whether you need to update, please log into Chintaro and see this solution: Which version of Chintaro is my Organisation currently running?


Are you running Chintaro SQLx? If you are not or if you are unsure do not update until you LOOK AT THIS LINK.


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. 


Updating Instructions 


Step 1. Ask all users to log out and check that they have done so.

Step 2. Download the latest version.

Step 3. Save it to your C:\Chintaro folder on your PC.

Step 4. Run the 3 scripts in SSMS.

Step 5. Launch Chintaro to make sure that the update was applied correctly.

Step 6. Log out of Chintaro.

Step 7. Copy the chintaroSQLx.accdb file to the Chintaro\Data folder.

Step 8. Copy the chintaroSQLx.accdb file from the Chintaro\Data folder to the C:\Chintaro folder for all users.

Step 9. Advise users that they can log in.


STEP 1.

Ask all users to log out and check that they have done so. You can check to see if all users have logged out by using this solution: System Maintenance - Current Users


STEP 2.

You will need to download the latest Chintaro version from the top of this solution. The link will open up to our Dropbox account on your web browser. Click Download to start downloading the file.



The file you just downloaded is a zip file containing 4 files. The chintaroSQLx.accdb file is the code database and the three ".sql" files are Microsoft SQL Server scripts that must be run before you launch Chintaro. The ChintaroSQLx client (chintaroSQLx.accdb) will usually be installed on the local drive (usually C:\Chintaro) of each PC that will be used to run Chintaro. This version is suitable for 32 bit or 64 bit Access databases users.


STEP 3.

Once you have downloaded chintaroSQLx.accdb from the website, copy this file (chintaroSQLx.accdb) to the location of your existing version. This is often C:\Chintaro but may not be. You can check the location by looking at the properties of the shortcut you usually use to launch Chintaro. The location of the Client file in this example is “C:\CHINTARO\chintarosqlx.accdb”.




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


STEP 4.

Before you launch Chintaro, you must run all of the scripts in the zip file in the SQL Server Management Studio (SSMS) in the order that they are numbered .


If there are additional scripts in the file, these can be run after the first 3 scripts.


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


STEP 5.

Launching the new version of Chintaro. Log in to Chintaro by double-clicking the shortcut file using your normal login details. You will see the following login dialogue box:


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 has updated to the latest version (under the Logo on the home page).



STEP 6.

Once you have confirmed that the update has applied correctly, log out of Chintaro so that you can update the other users.


STEP 7.

Copy your copy of chintaroSQLx.accdb from your C:\Chintaro folder and paste it in your Chintaro\Data folder. This folder is often on a shared network drive but may not be. If you are unsure where your Chintaro\Data folder is, please see this solution for instructions on how to find out: How to find the location of your Data Folder



STEP 8.

Copy the chintaroSQLx.accdb file from the Chintaro\Data folder around to all other user’s PCs. 



STEP 9.

Advise users that they can log in.