1. Home
  2. Labeling Software
  3. TEKLYNX CENTRAL
  4. Deactivate a Label – LABEL ARCHIVE / TEKLYNX CENTRAL Instructions

Deactivate a Label – LABEL ARCHIVE / TEKLYNX CENTRAL Instructions

Target Audience: Advanced User

Summary

This Instruction Article explains how to deactivate a label file in LABEL ARCHIVE /  TEKLYNX CENTRAL. Sometimes you may want to make sure that the old label cannot be printed by accident. By setting an expiration date for the label, you can force them to expire.

Preparation

  • Connect the Designer (i.e. CODESOFT to LABEL ARCHIVE)
  • Select Check Out from menu

  • Open SQL Management Studio
  • Connect to the "LABELARCIHVE" database

Instructions

  1. Right-click on the document during the Check-Out process
  2. Select Change Expiration Date
  3. Enter date (MM/DD/YYYY format)
  4. Click OK

The steps described below are meant for advanced users only. The user should possess a working knowledge of SQL Management Studio and must hold sufficient privileges in SQL server to perform this function. Use these instructions at your own risk

  1. Open SQL Management Studio and log in to the SQL server instance holding the LABEL ARCHIVE or TEKLYNX CENTRAL database
  2. Open LABELARCHIVE > Tables. Right-click dbo.tblDocuments and select Edit top 200 Rows (NOTE: Some systems may show a number other than 200 - this is configurable)
  3. It is likely that the desired document is not in the top 200 documents. In that situation, select the SQL button on the toolbar to modify the SQL select statement to locate the document you want. (State = 4, DOCNAME = <Label Filename>). Note: State=4 refers to approved document.
  4. Once the document is located, enter the desired expiration date on the EXPIRATIONDATE column and press enter. The date can be entered in MM/DD/YYYY format.

Updated on April 8, 2019

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support