Working With Huge Databases?

[soma]

I'm working with a 1gb database and have about 20 queries that analyze and summarize the database in different ways. I tried running a query that runs all 20 of these queries, but it's just too much to process.

Is there a way to, maybe, write a macro that runs each query, and stores the result from each query? Any ideas on how to automate the running of these queries, and store the results?

[MAF4Fam6]

Assuming ALL your 20 queries contain the same output fields:
1. Create a new table to store the results of each query
2. Change your query types from Select Queries to Append Queries (appends the resulting records to the new table).
3. Create a Macro and use the OpenQuery Action to run each Query.

-RC

[Microsoft Access Database]

You would need to change the query to become make table queries. It would then make a new table with your query results stored.