Link to the ODBC Data Source

To link to an ODBC data source:

1. Open Microsoft Access.

2. Select File > New.

   A New window opens.

   

3. Click on the Database icon to select it.
4. Click the OK button.

5. Click on the New icon  to open a New Table .

   

6. Click on Link Table to select it.

7. Click the OK button.

   The Link Table Dialog box opens.

   

8. Click on the Files of Type arrow and select ODBC Databases.

   A Select Data Source window opens.

   

9. Click on the Machine Data Source tab.
10. Select the source created during the ODBC source set up.

11. Click the OK button.

    The SQL Server Login box appears.

    

12. Uncheck Use Trusted Connection.

    The Login ID and Password box are enabled.

13. Enter JurisRPT as the Login IDSee. Leave the password field blank.

14. Click the OK button.

    The Link Tables box appears.

    

15. The Link Tables box will display. Click SELECT ALL and place a check in the Save password box.

16. Click OK button.

    The Save Password box may not be available if the Access database was previously linked to Juris® data.  There are two options to resolve this issue. Create a new Access database and link to the Juris data per these instructions. Delete all the tables from the existing Access database and re-link to the Juris data per these instructions.

    There will be several screens asking to select a unique record identifier.

    

17. Click OK on each of the "... select unique record identifier" boxes.