Setting up Microsoft Access

Follow

These instructions were written using the current version of Microsoft's MDAC and Microsoft Access 2013 as a guide. If you have a different version, the screens and process may vary slightly from the steps outlined here.

Prior to setting up a connection to Microsoft Access, you will need to create an ODBC link This will be the ILLiadLink utilized in step 7 below. For instructions on creating this link, see Setting up the ODBC Data Source Link

  1. Open Microsoft Access.
  2. Choose the option to create a new Blank Database.
  3. Enter a title for your database and click Create.
  4. To import your data source, click the External Data tab and then ODBC Database.
  5. Select Link to the data source by creating a linked table.
  6. Click the Machine Data Source tab.
  7. Select ILLiadLink from the list and click OK.
  8. Log in with the ILLiadLink login ID and password and click OK.
  9. A Link Tables box is displayed. To link all of the tables, click the Select All button and click OK.
  10. If any tables ask you to Select Unique Record Identifier, click OK. When this is finished, the link is complete.

 

 

Questions?

If this article didn’t resolve your issue, please take a moment and answer a few questions to help improve our documentation:

Feedback