Create MS Access Macro that can be used on multiple .mdb files

Asked By jakipaul 0 points N/A Posted 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?

• Status: Open
• Question Views: 1166
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by mathew202sss

Go To Solution

Best Answer

Best Answer

Answered By mathew202sss 0 points N/A #118475

Create MS Access Macro that can be used on multiple .mdb files

Hi Jakipaul,

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.

Thanks. 

About mathew202sss

Questions
0

Answers
18

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 08/28/2011
• Question Category: MS Access