Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

Message

The following "Error and Warning Messages" dialog box appears when a label is opened with either On Demand Print 32 or Range Print 32:

Error: UNP_MULTIDBKEY: Multiple Database-key fields accessing the same database.

Explanation

ODBC (Open Database Connectivity) is Microsoft’s interface for accessing data in database management systems (DBMS’s). It is through this mechanism that Loftware Label Manager (LLM) applications are able to access data within your database.

While multiple fields on a label can be connected to a database through ODBC, there cannot be more than one Database-Key field pointing to the SAME Data Source Name ( DSN ) and to the SAME Table. 

It's likely the label designer was running Design 32 with "Warnings and Errors" turned off ( Design 32 | View | no check mark next to "Warnings and Errors" ) otherwise the label designer would have been warned of this condition when the label was saved with a MULTIKEY error similar to that shown below.

Solution

  1. Using Design 32, open the label in question, locate the duplicate Database-Key field referencing the same DSN and Table as the other Database-Key field and either delete this field or change the Data Source property from Database-Key to a different Data Source ( i.e. Keyboard, Database-Data, etc. )

  2. If you are unsure which fields have a Database-Key Data Source, locating the fields having the same Database-Key Data Source can be made easier by

    1. Opening the Properties dialog box in Design 32

    2. Sorting all fields by their Data Source Type: (Options | Properties Sort | "Data Source | Type | Name")
    3. Locate the Database-Key fields from the drop down list within the Properties dialog box.  (See below)
      Note: Labels have a Design View and an On Demand Print Form View ( Design 32 | View | Label Design/On Demand Print Form ). 

 

 

 

Article Number

KBXXX

Versions

Loftware Label Manager versions 9.5 and higher.

Environment

All supported Loftware Label Manager environments

 

Rate

  • No labels