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.
ODBC (Open Database Connectivity) is Microsoft’s interface for accessing data in database management systems (DBMS). It is through this mechanism that Loftware Label Manager (LLM) applications are able to access data within your database.
It is common to find multiple fields on a label connected to a database through ODBC. There can be multiple Database-Data fields, and there may be one or more Database-Key fields referencing different DSNs or Tables. However, there cannot be more than one Database-Key field pointing to the SAME Data Source Name (DSN) and to the SAME Table.
It is likely the label designer was running Design 32 with Warnings and Errors turned off ( Design 32 > View > Warnings and Errors is not selected), otherwise the Label Designer would have been warned of this condition with a "MULTIKEY" error when the label was saved, similar to the following image.
Provide steps that the user can take to solve the problem. For example "The level 7 printer will flash red when it is out of paper. Add paper to tray 1".
|You may want to use a panel to highlight important steps.|
Using Design 32, open the label in question, locate the Database-Key fields referencing the same DSN and Table and either delete one of the fields or change its Data Source property from Database-Key to a different Data Source (such as Keyboard, Database-Data, etc.).
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:
Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.
See Using the Knowledge Base for information on how to the indicate the status of an article using the Status macro.
Loftware Label Manager versions 9.5 and higher
All supported Loftware Label Manager environments
This table provides article information that is visible only to Loftware users.