The formula for the "Combined Proportion Normal" endpoint used for bivalve and echinoderm larval development tests was in error prior to v1.8.7.14. The formula read: 'IIF([#Normal]>[Initial],[#Counted],[Initial])' and should read 'IIF([#Counted]>[Initial],[#Counted],[Initial])' or 'IIF([Final]>[Initial],[#Counted],[Initial]).' Please make this correction in your database under the 'Development-Survival' test type.
Why will the License Wizard not open and allow me to activate the CETIS license?
Check with your admin to make sure they are allowing Trusted Locations for the CETIS directory and its sub-directories. By adding the CETIS directory to Trusted Locations, Windows will not block the VBA and ActiveX components from running. Normally the CETIS directory is added to Trusted Locations as part of the installation, but your admin may block that by group policy. Also make sure that Windows Defender is not blocking the QlmLicenseWizard.exe file.
See additional discussion on Trusted Locations here
Why can I not setup measurements from the Test Design form?
It has been recently discovered that an index named InstrumentID in the tblMeasurements table was mis-configured. Since the index is unnecessary, is can simply be deleted. If you purchased an update or new purchase less than a year ago, you can get an update that will delete the InstrumentID index while running the Intensive Repair utility.
Why does the first report I print on a newly opened instance of CETIS take so long to render?
It has been recently discovered that this is a printer driver issue, not a database query or report issue. Find and load a more efficient printer driver.
Why can I no longer activate or release my CETIS license online with a version lower than v2.1.3.0
Versions of CETIS prior to CETIS v2.1.3.0 used a version of QLM that required TLS 1.1 to communicate with the license server. Web hosting services are abandoning TLS 1.0 and 1.1. This required CETIS to be rewritten with TLS 1.2 capable QLM v16. CETIS v2.1.3.0 can once again use online activation or deactivation while incorporating a more capable Soraco designed wizard for both online and offline activation or deactivation. You are advised to update as soon as possible. If your purchase was less than one year ago, you are entitled to a free update. A stand alone QLM Wizard has also been developed and can be made available to you. For legacy users, a Self-Help Portal has been added to this website under the Support menu.
"Why am I suddenly getting an error "Requested type library or wizard is not a VBA project" after updating to Version 2206, Build 15330.20246?"
This is a known bug that Microsoft introduced with Version 2206, Build 15330.20246. They have issued a patch with Version 2206, Build 15330.20264. Please update as needed.
See additional discussion here
"Why do I have to re-register the license after a Windows 10 update?"
Microsoft changed their algorithms for assessing registry keys and often without your permission, deletes critical keys required by software used on your computer. Starting with v1.9.6.xx, we have overcome this obstacle by switching to a file storage system so the need for re-registering the software should only be necessary with a major version change.
"Why is my backend database getting corrupted when shared from a server?"
Microsoft has finally acknowledged a LAN corruption bug they introduced back in November 2018 that started crashing Access databases in a shared environment. Unfortunately they have not addressed it yet through a Windows update and it is up to the user to implement a Microsoft sanctioned hack. A discussion here is a rather long winded discussion of the problem, indicating this is an unfixed and ubiquitous problem. You are strongly advised to consult with your IT professional to determine the best course of action if you experience this problem. Tidepool has done what it can do including the elimination of mapped drives and implementation of UNC network addressing for linked tables.
"How is CETIS installed on a Vista, Win7 or Win 8 Machine?"
Note: Starting with CETIS v2.1.x.x, the Graphic Server ActiveX control has been replaced with the TeeChart AX ActiveX control. The discussion below only applies to versions prior to v2.1.x.x
Starting with CETIS v1.9.0, all installations are performed with an installer, so the discussion below only applies to versions earlier than v1.9.0. The new installer eliminates most difficulties with getting dependencies registered.
Since CETIS requires the installation and registration of the Graphics Server ActiveX file, it is required that you temporarily disable the User Account Control (UAC) to allow the registration of the graphs32.ocx file. You can enable the UAC once you have successfully installed CETIS. Failure to take this step will prevent CETIS from opening. A clear indication that the Graphics Server ActiveX file has not been properly registered is when you receive an error such as "object or class does not support the set of events" during data analysis.
If your system security measures prevent the UAC from being disabled, register the Graphics Server ActiveX component manually from an elevated command prompt. To do this, right click on the icon for the Command Prompt on the start menu and select Run as Administrator. You will be prompted by UAC to approve the elevation. Once the command prompt window is open, run the following commands (without quotes), in order shown, from the command prompt window and it should succeed:
If 64 bit Windows:
"regsvr32 /u c:\windows\sysWOW64\graphs32.ocx"
"regsvr32 c:\windows\sysWOW64\graphs32.ocx"
If 32 bit Windows:
"regsvr32 /u c:\windows\system32\graphs32.ocx"
"regsvr32 c:\windows\system32\graphs32.ocx"
"I am suddenly getting an "Error 459" when trying to analyze data. Why is that and how do I fix the error?"
This is a known Microsoft bug introduced with a recent Office update and is corrected with a downloadable hotfix. Please see the Microsoft Knowledge Base article at http://support.microsoft.com/kb/945674 to download a hotfix solution.
Users are reporting that they have to re-register the Graphics Server ocx discussed in the above topic.
"I am using CETIS on a computer with Access 2003 SP3 installed and after calculating a dataset, the list boxes on the results form are blank. How do I fix that?"
This is a known Microsoft Access bug and is corrected with a downloadable hotfix. Please see the Microsoft Knowledge Base article at http://support.microsoft.com/kb/945674 to download a hotfix solution.
"I have installed CETIS into the Program Files folder on my Windows 7 machine. For some reason I cannot edit records. Why is that?"
Windows 7 and later prohibits read/write permissions for files in either the Program Files or Program Files (x86) directory. You will need to move the CETIS folder and it's contents to a location where read/write permissions can be granted, such as the root directory.
"I am trying to install a copy of CETIS on a second computer. Do I need to have a separate license for that?"
The end-user license agreement (EULA) allows you to install a single copy of CETIS on a single computer for each purchased license. Although multiple users can share the same backend database, each must be licensed to do so, or the software will intervene and lock one of the users out.
"A second user with a different Windows account is trying to open CETIS but gets a message that they do not have permissions to open and use CETIS?"
Note: Starting with v1.9.0, CETIS uses a special workgroup file referenced in a short-cut file. The discussion below mostly applies to versions earlier than v1.9.0.
Access 2007 has the unexpected behavior of creating a new system.mdw (Workgroup Information File) for every User Profile. Since only the person that installed CETIS will have the necessary security accounts installed in their workgroup information file, it follows that only they will have permissions to open CETIS.
This can be rectified by moving the system.mdw to a shared folder and then have all users that need to use CETIS join that workgroup. CETIS provides a command button named 'Workgroups...' on the startup screen that will allow you access to the Workgroup Administrator application.
Alternatively you can include the /wrkgrp command switch in the target field for the CETIS shortcut as described below:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\[path to CETIS.mde]\CETIS.mde" /Wrkgrp "C:\[path to the shared system.mdw file]\System.mdw"
NOTE: The paths to Msaccess.exe and the System.mdw file may be different on your computer. Make sure the paths in your shortcut accurately reflect the location of Msaccess.exe and System.mdw on your computer.
The normal location of the system.mdw file for XP systems is here:
"C:\Documents and Settings\[your user name]\Application Data\Microsoft\Access\System.mdw"
For post XP operating systems, the location of the system.mdw is here:
"C:\Users\[your user name]\AppData\Roaming\Microsoft\Access\System.mdw"
You can always move the system.mdw with the CETIS accounts installed to the CETIS folder, then add a /wrkgrp pointer to that location.
Later versions of CETIS shipped with a small app (file name wrkgrpadmin.mde). You can open this from the CD and by clicking the Workgroup button on the splash screen, a user can join the workgroup with the CETIS accounts installed once you have moved it to a shared location. The short-cut strategy with /Wrkgrp switch discussed above may be a better alternative, however.
"I am trying to add a sample to a test batch but I do not see a list of samples in the drop-down list?"
More than likely it is due to a sample date that is later than the test start date. CETIS will only display those samples whose sample date is earlier than the test date but less than the time span chosen.
"I have successfully created a test by adding a sample to a test batch. After entering some data, I decided to change the test type, but now my raw data that was entered is gone. Why is that?"
Once a test type is chosen and the test design has been specified, you cannot change the test type without entering raw data again.
"I am trying to change data in a form but the fields appear to be locked and cannot be edited. How do I edit data fields that appear to be locked?"
CETIS allows the user to lock various forms so that data are not inadvertently changed. You simply need to click on the padlock toggle button until the records are unlocked. When finished editing the data, you can re-lock the records by clicking on the padlock once again. CETIS will set the state of the padlock to what it was when the form was last closed.
"I need to paste data that has been copied from Excel. Why does the data not transfer over?"
As long as the dimensions of the array are the same, the data can be pasted into the Test Data form. Version 1.7.0 now includes a short-cut command that will automatically determine the dimensions of the array held in the clipboard and will select the same sized array in CETIS starting with the upper left-hand cell.
"Why does the 'Clone Test' dialogbox remain open after cloning a test?"
Previous version would complete the cloning and then close the dialogbox. It was reasoned that it is more efficient to leave the 'Clone Test' dialogbox open because it is common that more than one test is cloned at a time.
"I am using Access 2007 and the CETIS short-cut menus do not appear, only the default menus. What is wrong?"
A known bug in Access 2007 prevents the display of short-cut menus. Please see the Microsoft Knowledge Base article at http://support.microsoft.com/kb/935875 to download a hotfix solution.
"We are currently running the most recent version of CETIS on Access 2007, unfortunately, when we go to paste information from Excel we get an error message 'The data on the clipboard is damaged, so CETIS can't paste it...' How do I fix that?"
A known bug in Access 2007 prevents the pasting of Excel data from the clipboard into Access. Please see the Microsoft Knowledge Base article at http://support.microsoft.com/kb/935875 to download a hotfix solution.
