We have developed superior software Clisp Studio that's designed to deal with high pressure testing in laboratory environments. Our software can deal with extensive testing but is still simple to use and will benefit the technician during the entire conduct of the test.

Part one of our Clisp Studio guide took us through Displacement Transducer Calibration. Part two will focus on Database Facilities that are included when you are using the software.

Using Clisp StudioPart 2–Database Facilities

In order to perform this facility you must ensure:

a) CLISP Studio is up and running

b) A Client, Jobfile, Borehole and Sample have been set up

c) A number of Tests have been created to produce a Database and a separate Database backup is available if required.

Adding Other Database Users

This facility is useful if you want to allow another person on your network to have access to your Database.

From the 'Files' pull-down menu select the 'Database Connection…' option.

This will bring up the 'SQL Database Connection' window. From the 'Options' pull-down menu select the ‘Manage Database Users’ option.

This will bring up the 'Database Users' window shown below. To add another User, click on the highlighted 'Add' button.

This will bring up the ‘Add User’ window shown below. If the User’s Name and Domain is known it can be input, otherwise click on the highlighted ‘Browse’ button.

This will bring up the ‘Select User’ window. Click on the ‘Locations’ button highlighted, to find other Users on your network.

This will bring up the ‘Locations’ window shown below. Select the required Network and click on ‘OK’.

Back in the ‘Select User’ window, the network location will now be displayed (1). Type the name of the person you want to allow access to the Database in the Object Name box (2). To verify the User is present and to find the correct User name click the ‘Check Names’ button (3).

If the User is not found, an error message is displayed and the Database Manager should be consulted. If the User is found, the correct User name will be displayed in the Object Name box as highlighted below.

Click on ‘OK’ and the User will now appear in the Database Users window. Click on the ‘Apply’ button and confirm in the pop-up dialogue box to give the new User access to the Database before closing the window.

Backing Up A Database

This facility is useful when you want to backup your Database, either as a precautionary measure or to enable another Clisp Studio user to be able to restore it.

From the ‘Files’ pull-down menu select the ‘Database Connection…’ option.

This will bring up the ‘SQL Database Connection’ window as shown below. From the ‘Options’ pull-down menu select the ‘Backup this Database’ option.

This will bring up the ‘Save Database File’ search window as shown below.

Use the menu navigation system to find the Microsoft SQL Access Database backup area. The exact location will be dependent on your machine setup, but will be similar to that highlighted below. Give the Backup File a suitable name and click on the ‘Save’ button.

The backup file will now be saved as a ‘.bak’ file with your chosen filename and the window will be closed.

Restoring An Existing Database From A Previous Backup

This facility is useful when you want to restore one of your existing Databases or to load a ‘.bak’ Database made available by another Clisp Studio user.

If you have a ‘.bak’ backup file stored in a different location, move or copy it from that location into the Microsoft SQL Access Database backup area. The exact location of the Microsoft SQL Access Database backup area will be dependent on your machine setup, but will be similar to that highlighted below. There may well be a number of ‘.bak’ files present.

From the ‘Files’ pull-down menu select the ‘Database Connection…’ option.

This will bring up the ‘SQL Database Connection’ window as shown below. From the ‘Options’ pull-down menu select the ‘Restore a Database from a previous backup’ option.

This will bring up the ‘Open Database File’ search window. Use the menu navigation system to find the Microsoft SQL Access Database backup area. The exact location will be dependent on your machine setup, but will be similar to that highlighted below. There may well be a number of ‘.bak’ files present.

Select the Database backup you require and it will be highlighted and appear in the ‘File Name’ field and then click on the ‘Open’ button to open it. The screen will close, leaving the ‘SQL Database Connection’ window open.

Clicking on the Database pull down menu will show that the restored Database is present, as well as the current Database as shown below.

To load the new Database, select it so that it appears in the Database field and then click on ‘Select’ as shown.

The restored Database will now load and be ready for use on

Speak To Us For Help

We develop all our hardware and software with your needs in mind; we are dedicated to providing you with superior software that can be integrated with our advanced testing equipment.

If you experience any problems or have any questions about Clisp Studio then please contact a member of our team.

Please call: +44 (0) 118 945 3737 or Email: service@vjtech.co.uk.