N/APosted on - 08/24/2011
I am using Microsoft Access 2003. Is there a way to create a MS Access 2003 macro that I will take a table setup several queries, run the queries on it and output all the results to a single report?
I want to be able to do this on different database files. Each file has the same design. Is any of this possible?
How can it possible to create a MS Access macro that can be used on multiple .mdb files?
Create MS Access Macro that can be used on multiple .mdb files
This is what I found in my research based on your issue. You can link a table from an earlier Access file format to a database in a later version of Access, but you cannot link a table from a later version of Access to a database in an earlier version of Access.
For example, you can link from an .accdb database to tables in another .accdb database, or to tables in an .mdb database. However, you cannot link from an .mdb database to tables in an .accdb database. Come back to these tips if they helped you so I may know what would be the solution if they did not.