IDpack works perfectly with any type of ODBC Database connection: Microsoft Access Database on a network, a SQL Server, MySQL, Sybase or an Oracle database. The principle is always the same. Today we will show you step by step how to use IDpack with an ODBC connection to a Microsoft Access Database. For IDpack Business and IDpack Professional only.

Step 1

idpack designer workspace

Open IDpack Designer.

Step 2

idpack designer id card

Create your badge layout.

Step 3

idpack designer save badge

Save your badge in a folder. You will get a file with the extension .IDP (for IDpack Project) in your folder.

Step 4

idpack producer startup

Don’t close IDpack Designer and Open IDpack Producer. Click Open Badge and open the badge you just saved.

Step 5

idpack producer workspace

When you open a badge for the first time, IDpack Producer will create a Microsoft Access Database file (using the Field Definitions your specified in IDpack Designer) like this:

idpack files in folder

All your badges information will be saved in the database.

Step 6

idpack producer add badges

Add a few badges for testing (you can deleted them later if you want).

Step 7

idpack producer badges added

Now that we have some badges, let’s go back to IDpack Designer and setup the ODBC Connection.

Step 8

idpack designer badge setup database

Open the Badge Setup window and click Database Type tab.

Step 9

idpack designer badge setup database odbc

Select Database Source (ODBC) and click the ODBC Administrator button.

Step 10

windows odbc data source administrator

click Add… to create a new ODBC connection.

Step 11

create new data source

Select Microsoft Access Driver (*.mdb) in the menu and click Finish.

Step 12

odbc microsoft access setup

Click Select… to select your Microsoft Access Database file.

Step 13

select database

Go to the folder where you saved your badge layout and select your database. Click OK.

Step 14

odbc microsoft access setup

Now enter a Data Source Name in the text box. Description is optional, and click OK.

Step 15

idpack designer badge setup database odbc selected

Click Ok to close the Badge Setup window and re-open the Badge Setup to refresh the pull-down menu of the Data source name. We will fix that, so it will refresh automatically. Now select in the pull-down menu the ODBC connection you just created in step 14 .

Step 16

connection successful

Click the Test Connection button to make sure everything is working. Click OK, Ok on the Badge Layout window and save you badge with the new setup.

Step 17

idpack producer odbc connected

Go back to IDpack Producer and re-open your badge layout to reload the new setup. Your records should show up. Congratulation, you just setup your first ODBC connection with IDpack!





How to use IDpack with an ODBC Connection