***Before you move to SQLx, you MUST ensure that you have a full version of MSAccess installed on each machine that will run Chintaro. Chintaro SQLx will not work with Access RuntimeNot for Profit organisations can apply for a significantly reduced cost version of Office that includes the full version of Access. Click here for more information.***


ChintaroSQLx.accdb is the SQL version of Chintaro which does away with the rhp.mdw file, and introduces a new MDB developed security system. This will allow MDB to develop more user orientated features in the future, and should provide some moderate increases in performance, as well as doing away with the continual maintenance of the rhp.mdw file.


Another difference with ChintaroSQLx.accdb is that it uses an .accdb file format. The ACCDB file format replaces the older MDB format used in prior versions of Access (before version 2007).


What is the process for moving to ChintaroSQLx?


***Before you move to SQLx, you MUST ensure that you have a full version of MSAccess installed on each machine that will run Chintaro. Chintaro SQLx will not work with Access RuntimeNot for Profit organisations can apply for a significantly reduced cost version of Office that includes the full version of Access. Click here for more information.***


The process for moving from ChintaroSQL.mdb to ChintaroSQLx.accdb is as follows:


(Before moving, you must ensure that you are on the latest version of SQL ChintaroSQL180807. If you are on a version earlier than this, update to the version in this link before continuing: https://www.dropbox.com/s/pk198hckgfwlzru/chintaroSQL180807.zip?dl=0)


1. Download the ChintaroSQLx.zip file and the security tables script

2. Download the scripts in the zip file and run these 3, and also run the SecurityTables.sql script in SQL Server Management Studio (SSMS)

3. Edit the ChintaroINI.XML file

4. Copy the ChintaroSQLx.accdb file to 1 machine's C:\Chintaro Folder

5. Change the Chintaro shortcut on the desktop

6. Launch Chintaro and link to the ChintaroINI.XML file

7. Repeat steps 4 - 6 for each machine that uses Chintaro

8. Contact Support for assistance with setting up Users and User Roles



1. Download the ChintaroSQLx.zip file


Download the ChintaroSQLX.zip file from this link.


The zipped folder contains several files:


ChintaroINI.XML: The ChintaroINI.XML is an initialisation file that stores the connection string to your SQL Server database, and the location of your Chintaro data folder. This file is required when installing new releases of Chintaro, or if the the location of your database and files (eg templates) ever changes.

NOTE: Download this file from the bottom of this solution.


ChintaroSQLX.accdb: The code database that will replace the ChintaroSQL.mdb on each machine's C:\Chintaro folder 


Run 1st New Fields DATE.sql, Run 2nd ALL Functions and View CompleteDATE.sql & Run 3rd DATE Complaints.SQL:  Scripts that need to be run in order in SSMS


The Security Tables script at the bottom of this page (SecurityTables.sql) is another script that needs to be run in SSMS.


Unzip the files and copy them to the SERVER\Chintaro\Data folder. 




2. Download the scripts in this file and run these 3, and the SecurityTables.sql script in SQL Server Management Studio (SSMS)

Download the scripts attached to this solution.


Open SSMS. Run the 3 scripts you just downloaded, then, run the SecurityTables.sql script. Ignore any error messages you receive when running these scripts.


3. Edit the ChintaroINI.XML file

Open the ChintaroINI.XML file using WordPad. You will need to edit 2 sections of the ChintaroINI.XML file - the connection string and the location of the Chintaro\Data folder. 


Editing the Connection String: Open the current rhp.mdw file by double clicking, right click the arrow in 'All Access Objects' to open Navigation Options and turn on the Show Hidden Objects and Show System Objects. Click OK.



Move to the Tables on the left hand side and open UsysConnection:


Copy the entire Connection String text, and paste it in the ChintaroINI.XML file, here:


Close the rhp.mdw database.


Editing the Data Folder: The location of the Data folder will need to be edited in the ChintaroINI.XML file also. 


Open File Explorer and navigate to the Chintaro\Data folder. Copy this path and paste it over the existing data location in the ChintaroINI.xml file in the following place:


 Close the ChintaroINI.XML file and click 'Save'.



4. Copy the ChintaroSQLx.accdb file to 1 machine's C:\Chintaro Folder

Copy the ChintaroSQLX.accdb file from the SERVER\Chintaro\Data folder and paste it in the C:\Chintaro folder of 1 machine.

 


5. Change the Chintaro shortcut on the desktop

Right click the Chintaro icon on the desktop, and open Properties. In the Target Line, delete everything after the MSAccess location. *NOTE:You must leave the location of access if users wish to open more than 1 copy of Chintaro on their machine at any given time.* 




After MSACCESS.EXE" leave one space, then add the location of the ChintaoSQLx.accdb file:

Click 'Apply' then 'OK'.


6. Launch Chintaro and link to the ChintaroINI.XML file

Launch Chintaro and you will be prompted with the following message:



Click OK and navigate to your Chintaro\Data folder to locate the ChintaroINI.XML file. Double click on the ChintaroINI.XML file. The message will disappear, and Chintaro will present you with a log on box. 


Enter the username as admin and the password as admin



Chintaro will open and you will see the version has been changed to ChintaroSQLx.accdb:


IMPORTANT: You must check that the Data folder can be seen in Chintaro. You can do this by opening System Maintenance > Set Up Word Merges. To do this, drop the Template Name box down:


If you do not see a list of templates, you will need to log out of Chintaro and go back and change the ChintaroINI.xml file to point to the correct Data folder location (Step 3). If you change the data folder, you will need to reapply the code database (ChintaroSQLx.accdb) to the C:\Chintaro folder of the user's PC.


7. Repeat steps 4 - 6 for each machine that uses Chintaro

For each machine that uses Chintaro, you will need to: 

  • Copy the ChintaroSQLx.accdb from the SERVER\Chintaro\Data folder to the C:\Chintaro folder
  • Change the Chintaro icon on the desktop
  • Launch ChintaroSQL and locate the ChintaroINI.XML file
  • Log in to Chintaro as normal.

8. Contact Support for assistance with setting up Users and User Roles

ChintaroSQLx uses a new security system, and as such, you will need to contact Chintaro Support to assist you with re-adding your Users to the database, and assigning them with their User Roles. Contact support either emailing support@chintaro.com.au or phone 03 9111 2656 (AUS) or 09 888 9296 (NZ) to arrange a Go To Meeting.



For additional information about ChintaroSQLx or if you require help from Support

If you require assistance, please contact Chintaro Support via email (support@chintaro.com.au) or phone 03 9111 2656 (AUS) or 09 888 9296 (NZ).