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).
   
   
    
5. In the "Import & Link" group, select "New Data Source"
   
   
    
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
   
   
    
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"
    
    
     
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:

• List Voyager Prepackaged Access Reports queries added or modified since a specific date
• List Voyager Prepackaged Access Reports tables added or modified since a specific date
• List Voyager Prepackaged Access Reports reports added or modified since a specific date

• Article last edited: 07-Nov-2019