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
Open IDpack Designer.
Step 2
Create your badge layout.
Step 3
Save your badge in a folder. You will get a file with the extension .IDP (for IDpack Project) in your folder.
Step 4
Don’t close IDpack Designer and Open IDpack Producer. Click Open Badge and open the badge you just saved.
Step 5
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:
All your badges information will be saved in the database.
Step 6
Add a few badges for testing (you can deleted them later if you want).
Step 7
Now that we have some badges, let’s go back to IDpack Designer and setup the ODBC Connection.
Step 8
Open the Badge Setup window and click Database Type tab.
Step 9
Select Database Source (ODBC) and click the ODBC Administrator button.
Step 10
click Add… to create a new ODBC connection.
Step 11
Select Microsoft Access Driver (*.mdb) in the menu and click Finish.
Step 12
Click Select… to select your Microsoft Access Database file.
Step 13
Go to the folder where you saved your badge layout and select your database. Click OK.
Step 14
Now enter a Data Source Name in the text box. Description is optional, and click OK.
Step 15
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
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
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!