SQLape® INPATIENT SOFTWARE – HELP
In order to help you to find the causes of anomalies, SQLape-2016.accde application generates the file execution.csv, along with the results files. This file provides you with information on the problematic step (CHP = preparing Cases, Health problems and Procedures files), with the duration of its execution (T0 = beginning, T1 = end) and with a number of error or explanation text. Below, you will find a list of problems encountered by SQLape® users along with their causes and solutions. If you are not able to solve your issue with the information available on this page, please send us an email with your execution.csv (if available) and your SQLape_input.txt file.
Error: « 2950 »
Cause: Macros are prevented to execute on your PC.
Solution: Manually authorise the execution of macros on your PC. Example for Access 2010: Menu Files / Options / Trust center / Trust Center settings / Macro settings / Enable All Macros.
Error: SQLape software stops without creating all the TXT and CSV results files
Cause 1: The most current cause (including “file not found”) is related to functioning of the dongle.
Solution 1: The « fortress » dongle should install itself. If this is not the case, it is possible to install it manually using the « Install dongle.exe » application, which you can obtain by contacting us at info@sqlape.com
Cause 2: SQLape_input.txt is not correctly formatted.
Solution 2: Make sure your SQLape_input.txt follows the requirements. Notably control that it includes the proper number of variables, has semicolon (“;”) as separator and a CR (“carriage return”) at the end of each record.