my db is having a nervous breakdown!! HELP!!

[abordeau]

I have a db that is quite large, and since I am new"er" at using access, I'm sure I didn't design it in the most efficient way. My db has grown so large in fact that after a few operations it starts having a nervous breakdown and says "cannon open any more databases". (or whatever the message says).

So I created a practice db to try to consolidate and still get the same information. I need statistics on 13 different machines and all the queries are designed the same way as in my sample that I have attached.

Use my date selector and enter dates 7/1 and 9/30 for the three month range, and 4/1 and 9/30 for the 6 month range. click on "run query".

The final query MECH H36 QUERY is the result but you can see that it needs 4 supporting queries to get the correct data. I was hoping someone could show me how to get the same information using maybe 2 queries. I am sure you can imagine how many queries I have in my original.

Thanks in advance for any help you can give.

Angelina

 

[namliam]

not sure if this is a problem or not, but in your code your not closing and cleaning up your oAccessObject by doing something like:

Set oAccessObject = Nothing

 

[abordeau]

thanks I will give it a shot