Speed Is An Issue--Is Something More Robust Needed?

[mpoor]

I have a recently compacted & repaired 236kb Access file. I have four tables linked (coming from other copacted databases). I created a union query which contains the following statement:

SELECT [2 Record_id], [2 Email_addr], [2 Male], [2 State]
FROM 20020408EFXMainFileA
WHERE [2 Male]="1"

UNION SELECT [2 Record_id], [2 Email_addr], [2 Male], [2 State]
FROM 20020408EFXMainFileB
WHERE [2 Male]= "1";

The query takes more than 5 minutes to run. I need to revise the sql to include 7 or 8 more statements but I fear, if I do, that the thing will take forever to run. Am I doing something wrong? Is my server/PC robust enough for the task. See my server/pc specs below:

O/S: WIN2K Member Server
Memory: 256 mb
CPU: 650 mhz
Hard Drive: NTFS w/C:Master & D:Slave
C: 2 gig left
D: 6 gig available
Software: Access2K (only have this one application on the system)

 

[fluteplr]

You will prbably have better luck posting this in the access forum.

 

[mpoor]

Many thanks, I'll do that... mp

 

[moonshadow]

Have you got indices on the [2 male] fields?