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

    Import queries from one Voyager prepackaged Access Reports.MDB file to a different prepackaged Access Reports.MDB file

    1. Last updated
    2. Save as PDF
    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Question

    We are upgrading and I have some custom Prepackaged Access Reports queries (SQL) in my Reports.MDB file.  How can I move those to my "new" Reports.MDB file?

    Answer

    1. After you have upgraded and  linked your "new" Reports.MDB file and it is fully functional, have both your "old" Reports.MDB file and your "new" Reports.MDB file on the same computer.
    2. Open your "new" Reports.MDB file.
    3. Open "Queries" in the left-hand pane.
    4. Select "External Data" from the Access top menu bar (note that the following screenshots show Access 2016; your version may vary).

      query3.jpg
       
    5. In the "Import & Link" group, select "New Data Source"

      query4.jpg
       
    6. Select "From Database"
    7. Select "Access"
    8. Use the "Browse" button to navigate to the location of your "old" Reports.MDB file and select it.
    9. Select the "Import tables, queries, forms, reports, macros, and modules into the current database" button

      query2.jpg
       
    10. Click "OK"
    11. The "Import Objects" Window will open.  Highlight a single Query that you want to copy to your "new" Reports.MDB file and click "OK"

      query1.jpg
       
    12. You should receive a pop-up Window that your object was successfully imported.
    13. Repeat as necessary.
    14. Test your imported queries.  Note that some changes to the database may render "old" queries unusuable and they will need to be edited/recreated.

    Additional Information

    Helpful hints:

    1. Always make backup copies of your working Reports.MDB file.
    2. When creating custom queries, add a prefix (like your initials) to the query name.  All your custom queries will then be sorted together and easier to identify.
    3. Don't forget to export/import any corresponding formatted reports and other objects that you might have with your custom queries.
    4. If you import a query and there's already a query of the same name present, the Import will not replace one with the other. Instead, it will keep both. The imported query will have a "1" appended to the end of the name.
    5. You can also use a manual workflow to copy/paste each query individually from one file to another.

    See also:

     

    • Article last edited: 07-Nov-2019