RSS

Navigation





Search the wiki
»

PoweredBy

itrezzo Technical Support Wiki

Alternate Data Source - Microsoft Access Database



Microsoft Access

There are some cases where critical contact information has been stored in a Microsoft Access Database. This data is not easily accessible and there is no easy way to extract specific contact details. In addition, this information will not synchronize with a handheld device. This allows the contacts to fall out-of-date and erroneous information to be present.

Setting up an Access Database as an Alternate Contact Source in itrezzo

  1. Open the itrezzoAgent Administrator
  2. Expand the EPS Container
  3. Right-click on Alternate Contact Source
  4. Select 'Add Data Source'

Configuring Alternate Data Source - Using Microsoft Access

Configuring Alternate Data Source - Using Microsoft Access

  1. Type in the name you would like for this Alternate Contact Source
  2. Select the 'Edit' button
  3. Left-click on the 'Connection Type' dropdown and select the appropriate data connection type (Access 2007 or Access 2003 and earlier)
  4. For Access Database, you will enter the file location
  5. Select 'OK'
  6. You may optionally select the 'Test' button to test your connection
  7. Enter your query string for the data you wish to obtain
  8. An example of a connection and query string is given below:

Name: Access Data Source
Description: Test data source
Connection String: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\sj2-ex2\transfer\DDK\DataSources\ContactExport.mdb;
Query String: Select *,EmailAddress as Email1, Email2Address as Email2 from [Contacts]

Configuring Alternate Data Source - Using Microsoft Access

Configuring Alternate Data Source - Using Microsoft Access

  1. Select 'Run'to view the results of your query
  2. Select 'OK'

Setting an Access Database as a Mandatory Contact List

  1. Open the itrezzoAgent Administrator
  2. Expand the EPS Container
  3. Expand Alternate Contact Sources
  4. Right-click on the Data Source
  5. Select 'Make Mandatory Contact List'
  6. Click on 'Select' button within Target:Authorized Recipients section
  7. Select from the Global Address List (GAL) users or Active Directory (AD) distribution lists you would like to push the public folder contacts to
  8. Select 'OK'

Note – It may be important for an admin to select the 'Include contacts with no email address' option when using Alternate Data Sources as a Mandatory Contact List. There may be instances where there is no primary email address and contacts will still need to be pushed to users.

Sample MS Access file

  • A sample Microsoft Access file (zipped) is available here for download. 

itrezzo Support Wiki version 3.0.5.619. See the itrezzo web site or the itrezzo blog site to learn about contact management on your smartphone.

The Trademark RIM® BlackBerry® Smartphone and BlackBerry® Enterprise Solution is owned by Research In Motion Limited and is registered in the United States and may be pending or registered in other countries. The owner of this wiki site is not endorsed, sponsored, affiliated with or otherwise authorized by Research In Motion Limited.

Microsoft Outlook, Microsoft Exchange Server, Microsoft Active Directory, Microsoft Windows Mobile are trademarks of Microsoft.