Error Messages

The Crosstab Export in Enviro Data Version 2012 B 1.987 and Version 8 uses Microsoft Visual Basic for Applications (VBA) in Excel to create the final spreadsheet report. When the export is run, a VBA macro attempts to set or get the printer page setup properties for the sheet(s) in the Excel workbook. If a printer is not installed, an error will occur as Excel cannot set the page setup properties. See here for more details.

To correct this error when you already have a printer installed, you need to make that printer the default. If you do not have an installed printer, add a printer to Windows and make it the default printer. We recommend setting as a printer the Microsoft Print to PDF.

To change or set the printer In Windows 10 open Settings --> Devices --> Printers & Scanners and select/install a printer. Generally, you should let Windows 10 manage the default printer. To allow this, check the check box shown at the bottom of the figure below.

In older versions of Windows, the settings to add a printer and make it the default may be found in the Control Panel.

See What causes a 'Record To Large' error when creating a crosstab?

When you open a database, Access creates a "Lock file" with the extension ".LDB". When you close a database, that lock file should be removed but an error can prevent this. You can fix this by first closing all Enviro Data programs. In Windows File Explorer searching the folder C:\Envior\EData8 folder for a file with an LDB extension and delete it.

If you are unable to fix this error, contact support@geotech.com.

Starting with Version 8 B, the calculations routines have been revised to always re-calculate if results have been added to the Analyses table. If results have been edited or re-imported, if a Display Options setting has been changed, or as in the case of some existing data calculated with incorrect units, the re-calculated values are always based on current and correct information.

Additionally, the calculations always use the Parameter Units that are set up for the parameter and matrix, in the Parameters table so make sure parameter units are set up correctly. And, for results with inconsistent units, always set Display Options to perform Unit Conversions.

With Concurrent Use licensing in Enviro Data a lock file (supplied by Geotech) is installed in a folder (usually on a server) that is visible to all prospective users. This file, GCSLicense.mde, tracks how many licenses have been purchased and how many are currently in use. For a virtual machine (VM) it can be placed in the Enviro folder. For more than one VM, it can be placed on a shared drive. For a SQL back-end, either would be fine.

This lock file also allows you to “check out” a license so you can use Enviro Data while not connected to your network. Note that until a checked-out license is checked back in, it will not be available to any other users. However, the lock file does allow for a fixed number of overuses in emergency situations. If you exceed your licensed usage both you and Geotech will be notified.

If you have exceeded the allowed number of overuses, or a situation exists where a computer or VM that had a license checked out has not or cannot be checked back in, the license file will need to be reset to make it available again. This will require opening the lock file, GCSLicense.mde and editing it.

If you cannot locate the license file you can open the file GCS.lic in another computer’s Enviro Data directory, C:\Enviro\Edata8, using a text editor like Notepad and you will find the path to the license file there. However, when doing this be careful not to make any changes and close this file without saving it.

Use Windows Explorer to switch to the folder that contains GCSLicense.mde. Double click on this file and it will open in MS Access. Create and run the query shown below.

SELECT * From CheckOut

This query will open the table shown below.

Identity the record of the computer that needs to be checked back and highlight it. Then, simply delete the record by pushing the Delete key. This will free up the locked license and allow another user to use it. The records should now look like the one shown below. Simply close the table, open the EDITOR and VIEWER, and follow the instructions to connect to the license database.