IDpack 9
IDpack ID Card Software for ID Card and ID Badge Design and Printing
Home Products Download Purchase How-To Video Support Contact
Home Products Download How to Buy How-To Video Support Contact
 Home » Support » IDpack Element » IDP_USER

IDpack Element v9
Online Help

Search the help

Get IDpack Help in your language

IconWelcome to IDpack 9
IconIntroduction
IconWhat's New
IconAbout IDpack 9
IconSystem Requirements
IconDocumentation conventions
IconLicense Agreement
IconInstall - Uninstall
IconInstall Instructions
IconUninstall Instructions
IconGetting started
IconIDpack Designer
IconIDpack Producer
IconIDpack File Extensions
IconKeyboard shortcuts
IconIDpack Designer Keyboard Shortcuts
IconIDpack Producer Keyboard Shortcuts
IconIDpack Designer
IconGetting Started
IconWorkspace
IconMenu
IconFile
IconNew Badge
IconNew From Template
IconOpen Badge
IconOpen Recent
IconOpen File Location
IconInsert
IconTools
IconBadge Setup
IconBadge Layout
IconPlastic ID Card
IconPaper Format
IconCreate or Modify Paper Format
IconDymo LabelWriter
IconLabel Printer
IconProducer Setup
IconColor Code
IconSecurity
IconNone
IconBasic
IconDatabase Type
IconMicrosoft Access Database
IconField Definitions
IconImage Editor
IconOriginal Image Properties
IconEffects
IconCrop
IconFlip
IconResize
IconRotate
IconFilters
IconBrightness and Contrast
IconColorize
IconSharpen or Soften
IconLock Guidelines
IconHide Guidelines
IconClear all Guidelines
IconShow Dot Grid
IconIDpack Conversion
IconIDpack Update
IconBadge Properties
IconOptions
IconLanguages
IconToolbar
IconToolbox
IconPick Tool
IconGraphic Tool
IconDynamic Graphic Tool
IconDynamic Graphic File Tool
IconRectangle Tool
IconText Tool
IconDynamic Text Tool
IconDynamic Text Graphic Tool
IconColor Code Tool
IconCustom Dynamic Text Tool
IconPicture Tool
IconBarcode Tool
IconBarcode
Icon2D Barcode
IconDate Tool
IconColor Palette
IconStatus Bar
IconIDpack Producer
IconGetting Started
IconMenu
IconFile
IconOpen Badge
IconOpent Recent
IconOpen File Location
IconExport
IconPage Setup
IconPrint Buffer
IconPrint Badge List
IconEdit
IconReload List
IconSimple Find
IconFind Next
IconBadge List Find
IconBadge
IconAdd Badge
IconEdit Badge
IconDuplicate Badge
IconDelete Badge
IconSend to Buffer
IconMultiple Send to Buffer
IconCapture Picture
IconImport Picture
IconExport Picture
IconTools
IconPrint all Badges in Badge List
IconPrint Selected Badges
IconPrint with Hologram Ribbon
IconLock IDpack
IconCompact Database
IconDirect Command with Printer
IconClear Buffer
IconCamera Setting
IconPicture Filters
IconOptions
IconGeneral
IconBarcode
IconLanguage
IconToolbar
IconBuffer
IconQuick Find
IconPrint Activity
IconBadge List
IconSort Order
IconList Find
IconBadge Information
IconPrint Preview
IconActivate in Designer
IconActivate in Producer
IconFind or Search Methods
IconDatabase
IconDatabase
IconIDpack Database Structure
IconIDP_USER
IconIDP_STAT
IconIDP_SECURITY

IDP_USER

TABLE: IDP_USER

Field name

Data type

Length

Description

idp_id

AutoNumber, Primary Key

n/a

Unique Serial Number to identify a record

idp_colorcode

Number (Long Integer)

n/a

Number from 0 to 13 to specify a Color Code. If you are using a different coding system, you can create a table with 2 fields to match our system and link to it. If you do not use it, put NULL by default.

idp_desc1

Text, Number or Date/Time

250

Content field #1

idp_desc2

Text, Number or Date/Time

250

Content field #2

idp_desc3

Text, Number or Date/Time

250

Content field #3

idp_desc4

Text, Number or Date/Time

250

Content field #4

idp_desc5

Text, Number or Date/Time

250

Content field #5

idp_desc6

Text, Number or Date/Time

250

Content field #6

idp_desc7

Text, Number or Date/Time

250

Content field #7

idp_desc8

Text, Number or Date/Time

250

Content field #8

idp_desc9

Text, Number or Date/Time

250

Content field #9

idp_desc10

Text, Number or Date/Time

250

Content field #10

idp_desc11

Text, Number or Date/Time

250

Content field #11

idp_desc12

Text, Number or Date/Time

250

Content field #12

idp_desc13

Text, Number or Date/Time

250

Content field #13

idp_desc14

Text, Number or Date/Time

250

Content field #14

idp_insertdate

Date/Time

n/a

Insertion date of the record

idp_moddate

Date/Time

n/a

Last modification date of the record

idp_barcode

Date/Time

n/a

Last barcode scan date of the record

idp_picture

Date/Time

n/a

Last capture date of the record

idp_photos

OLE_Object

n/a

Picture saved to database table

idp_picturesize

Number

n/a

Binary size of saved picture to database table

clip0076Note

1.Field name can be changed to match your database fields. This will not affect the field labels used within IDpack Designer and

IDpack Producer as the labels are based on the Description field.

 

2.idp_id data type can be changed within IDpack Designer to one of the following data types.
•String
•Numeric (default data type)

 

3.idp_photos is the field where the capture or imported photo will be saved in the database.
•OLE_Object is the MS Access data field type.

 

4.idp_picturesize is the field where the size of the data contain in the idp_photos field will be saved. The field will be automatically created when the badge is first open in Producer only if the option to save the picture to the database is selected

   in IDpack Designer. If not you will need to add this field manually.

 

You must set the data type when creating the Badge Layout and before opening the badge in IDpack Producer for the first time.
IDpack from InnoTechnix is the most comprehensive and flexible solution for ID card and ID badge production on the market. IDpack helps organizations enhance their security requirements with access control cards, membership cards, convention badges, Student ID cards, employee ID, event passes, library cards, and other identification needs.

About | Products | Partners | Download | Purchase | Support | News | Contact | All prices are in USD Dollars Terms of Use | Privacy Policy
IDpack is part of the InnoTechnix Network. © 1999 - 2013 - u:6