Error 10002. The database cannot be used

In most cases, this error indicates that Freezerworks Server is not running. Check the server to see if Freezerworks Server application or service is running.

If the client is being used for the first time you may need to specify the IP Address and port number for the Freezerworks Server.

Close the client application.
Double-click the client icon and hold the ALT key.
Switch to the Custom tab on the resulting window.

-Database Name-Anything can be entered here. This is simply a label for the connection.

-Network Address-Enter the IP Address of the server followed by a colon and the port number for Freezerworks. The default port number is 19813 (xxx.xxx.xxx:19813).

When starting Freezerworks or Freezerworks Unlimited for the first time after installation, the program flashes on the screen and then quits.

When starting Freezerworks or Freezerworks Unlimited for the first time after installation, the program flashes on the screen and then quits.

When starting Freezerworks or Freezerworks Unlimited for the first time after installation, you may notice that the program flashes on the screen and then quits. This is an indication that you may need to add it as an allowed program in Data Execution Prevention (DEP).

Data Execution Prevention (DEP) is a security feature in Windows XP (Service Pack 2) and Windows 2003 Server (Service Pack 1). See Microsoft’s Knowledge Base Article 875352 for more information.

To add Freezerworks as an allowed program, follow these steps:

  1. Go to the System Properties:
    1. Right-click on the My Computer icon and select “Properties”, or
    2. Start-Run, type sysdm.cpl, and click OK
  2. Click the “Advanced” tab.
  3. In the “Performance” section, click Settings.
  4. Click the “Data Execution Prevention” tab.
  5. Select the radio button for “Turn on DEP for all programs and services except those I elect”.
  6. Click the “Add” button.
  7. Browse to the folder where Freezerworks is installed, and select the executable file (Freezerworks*.exe).
  8. Click Open, and click OK twice.
  9. Restart the computer for this change to take effect.
  10. Start Freezerworks.

How can I use Import to update aliquot data in Freezerworks?

Freezerworks will require a unique identifier to be included in the import in order to select which aliquots are to be updated. Freezerworks will accept:

  • The Unique Aliquot ID (system generated unique number for each aliquot)
  • A unique User Defined Field (must have the unique property selected)
  • Aliquot Number combined with a unique sample level field.

Select the appropriate Modify option at the Import Type page (e.g., “Aliquots”, “Samples with Aliquots”). At the Fields page, indicate your unique aliquot identifier field at the Select the field(s) used to uniquely identify each aliquot box.

What delimiter settings should I use when importing data?

The following are the most common delimiter settings. You may need to adjust the settings based on the source of your data file.

Mac OS: Field delimiter=Tab, Record delimiter=Return.

Windows OS: Field delimiter=Comma (except when there are commas in the data, then use Tab), Record delimiter=ReturnNew Line.

For best importing results, save the file in the operating system running Freezerworks. For example, if you create an import file using Excel in Macintosh, and want to import it into Freezerworks running in Windows, open and save it in your copy of Excel in Windows. Save it as a text file (with a CSV or TXT extension).

To save Excel spreadsheets as Tab delimited while using Mac OS select “Windows Formatted Text (.txt)” not “Tab Delimited Text (.txt)”. The import may not work properly if the file is saved as “Tab Delimited Text (.txt)”.