Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Relink Prepackaged Reports after Upgrade

    • Article Type: Q&A
    • Product: Voyager
    • Product Version: All
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care

    Question

    How to relink Prepackaged reports (Reports.mdb) after a Voyager upgrade?

    Answer

    1. Open Reports.mdb
    2. For Access 2007, 2010: Under External Data > ODBC Databases, select "Link to the data source by creating a linked table" and click OK.
    3. Select Data Source box opens; click Machine Data Source tab
    4. Click VGER.
    5. Click OK.
    6. Enter read-only username and password for your database instance and click OK.
    7. Link Tables box opens; click Deselect All. This step may take some time to complete.
    8. Click OK
    9. Under Forms, double-click Build database links to Voyager.
    10. Fill in the form:
    ODBC Name: VGER
    Connect string: VGER
    DB User ID: {read-only user for your database instance}
    Password: {read-only password for your database instance}
    Tablespace: {name of your database instance}
    Tablespace may need to be all caps
    1. Ensure Relink checkbox is checked
    2. Click Connect.
    Database tables will link; this may take anywhere from several minutes to several hours. For every successfully linked table, this message will display:
    {table name} linked successfully!
    1. To identify any tables that were not linked, run the "System Access Tables NOT Linked" query.

    Additional Information

    NOTE: These steps assume that ODBC drivers were installed prior to the upgrade.

     


    • Article last edited: 18-Aug-2015