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.