ODBC TimeOut Expired

[cableguy47905 via AccessMonster.com]

I have built a DB that is based on three different "linked tables". The
tables are actually Exchange Server folders full of email. The subject line
has the Project# that I need to extract out. I use several queries to do
this. The three folders represent the different status' of the project.
Pending, Reported, or Resolved.

I take each folder and extract out about 5 fields and add a field that will
represent the status. This query will also get the Project # out of the
Subject line. I then use this query as the base for determining where in the
process each project is. Meaning I do a few unions or "Unmatched records"
queries to find this out.

The folders are pretty large by themselves. I can run most of the first
queries with no problem, but when I try to run the unmatched queries or the
final query that is based on it, then Access either locks up or will give me
the ODBC TimeOut Expired error. I have gone through and set all of the
queries timeouts to zero, that didn't work, so I then set them all to 120. I
figure if I have to wait 2 min on a search, then I am going about this all
wrong anyway.

Maybe my architecture is all wrong. I can't really figure out how to speed
up the process unless I make tables out of the first set of queries and then
base the rest off of that. However, I am not very good at the automation
part and It would not be productive to manually make a table each time I want
to search for a project.

Any Ideas?

TIA,

Lee

I can give any or all code or SQL that is needed to help in figuring this out.

 

[cableguy47905 via AccessMonster.com]

OK, I think I figured this out. I wanted to give an update in case it might
be able to help anyone else.
The tables that are linked to the email folders are too large to be able to
run queries off of without timing out. So, I first made three Make Table
queries to be able to bring in all of the emails from the last 12 months and
this should give a good start. Then I have set up three unmatched queries
that I will use to be able to separate any of the new emails in the last
seven days from the ones that I already have recorded in my tables. Then I
use append queries based on those unmatched queries so that I can then update
my tables with the new emails. This has worked so far without timing out.