Skip to main content
  • 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


    How to relink Prepackaged reports (Reports.mdb) after a Voyager upgrade? (If you migrated to new server hardware please see "Additional Information" at the bottom of this Article).


    These steps assume you previously installed and configured ODBC as per these instructions: Installation and Configuration of ODBC for Voyager 

    Relinking tables can take a long time: 30 - 60 minutes on average.  But it can take even longer than that.  

    1. Open your new Reports.mdb file that is for your new version of Voyager.
    2. For Access 2007, 2010 and later: 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 will likely 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

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

    If you migrated to a new server and the server's IP address changed, you will need to edit the tnsnames.ora file on your workstation. 

    Microsoft Access 2013/2016/2019 32-bit is supported for use with Voyager.




    • Article last edited: 18-May-2020