How do I set up a Microsoft Access Link for the OCLC ILLiad Hosted Site?

Symptom

• You want read access to the SQL Server to set up a customized query using Microsoft Access.

Applies to

• ILLiad

Resolution

You need to contact OCLC to get the credentials you will need to use Microsoft Access.

1. You will need to follow the documentation for Setting up the ODBC Data Source Link.  Wherever you see the ILLiadLink Login ID, you will replace it with the ILLiadLink Login ID OCLC gives you.
2. You will need to follow the instructions for Setting up Microsoft Access.

Additional information

Here is the list of ILLiad Database Tables.

If you have any questions about the process, please contact OCLC Support.

Page ID