Creating an ODBC Connection for a Jenzabar-Linked Microsoft Access Database

Step 1: Install or Update the ODBC Driver

  1. Download msodbcsql.msi from the Files section of this page.
    • Alternatively, browse to:
      \\cccmain\Dept_Data\All Share\ODBC Drivers
  2. Double-click msodbcsql.msi and select Run.
  3. On the Welcome screen, click Next.
  4. Accept the license agreement and click Next.
  5. For ODBC Driver for SQL Server SDK, select Will be installed on local hard drive.
  6. Click Next, then Install.
  7. If prompted, click Yes to allow the installation.
  8. Click Finish when the installation is complete.

Step 2: Create the ODBC Connection

  1. In the Windows search bar, search for and open ODBC Data Sources (64-bit).
  2. Select the System DSN tab and click Add.
  3. Choose ODBC Driver 13 for SQL Server, then click Finish.
    • Don't see Driver 13? Verify that you completed Step 1. If necessary, restart your computer and try again.
  4. Complete the connection information:
    • Name: Enter the DSN name used by your Access database.
      • Most departments use: EX6: Jenzabar EX
    • Description: Leave blank.
    • Server: Type JZCCR-SQL1.cedarcrest.local
      • Tip: Type the server name instead of using the drop-down list, as Windows may take a long time to search.
  5. Click Next.
  6. Leave With Integrated Windows authentication selected and click Next.
  7. Check Change the default database to, then select the database used by your Access database from the drop-down list.
  8. Leave all remaining settings at their default values and click Next.
  9. Click Finish.
  10. Select Test Data Source to verify the connection.
  11. If the test is successful, click OK to close all windows.

Step 3: Verify the Connection

Reopen your Microsoft Access database and verify that the linked tables and queries open correctly.

 

Print Article