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.
Resolution
You need to contact OCLC to get the credentials you will need to use Microsoft Access.
- Follow the documentation for Setting up the ODBC Data Source Link with these changes:
- The server should be the SQL Server URL, e.g., abc-db.illiad.oclc.org.
- The login link ID is what OCLC gave you for the username, e.g., ABCLink.
- The default database should be the name of the Database name, e.g., ABCData.
- If you encounter errors, be sure to avoid clicking down arrows during configuration (except to change READWRITE to READONLY).
- You will need to follow the instructions for Setting up Microsoft Access.
Page ID
20294