Problem importing a table

[Ned Balzer]

I have a query that runs OK on local tables in an mdb file that was
originally created in Access2003. But if I import the tables to a new
Access2007 mdb, and try to run the same query, it hangs. I suspect
corruption in the imported tables (the query runs fine against the
original linked tables that the local tables were originally created
from, even when the query is run from the new .mdb).

Has anyone seen this sort of problem before? Is there anything I can
do to prevent it, or fix it after it happens?

Thanks in advance.

-- Ned Balzer

PS Here is the query syntax: SELECT DISTINCT loc_tcm.code_univ_yr_sem
AS SEMESTER, loc_tcm.code_csec_loc, loc_tcm.code_csec_delivery,
loc_tcm.code_csec_crse_key, Left(loc_TCM.code_CSEC_crse_key,5) AS
COURSENAME, Mid(loc_TCM.code_CSEC_crse_key,6,4) AS COURSENUMB,
loc_tcm.numb_csec, loc_tcm.code_csec_cancel, loc_tcm.code_csec_acdt,
loc_tcm.code_csec_coll, loc_csec_instructor.numb_csec_insr,
loc_csec_instructor.pcnt_csec_insr_effort,
loc_instructor_bio.NAME_EMPL_LAST_LEGAL,
loc_instructor_bio.NAME_EMPL_FIRST_LEGAL
FROM (loc_tcm INNER JOIN loc_csec_instructor ON
(loc_tcm.code_univ_yr_sem = loc_csec_instructor.code_univ_yr_sem) AND
(loc_tcm.code_csec_loc = loc_csec_instructor.code_csec_loc) AND
(loc_tcm.code_csec_delivery = loc_csec_instructor.code_csec_delivery)
AND (loc_tcm.code_csec_crse_key =
loc_csec_instructor.code_csec_crse_key) AND (loc_tcm.numb_csec =
loc_csec_instructor.numb_csec)) INNER JOIN loc_instructor_bio ON
(loc_csec_instructor.numb_csec_insr =
loc_instructor_bio.NUMB_CSEC_INSR) AND
(loc_csec_instructor.code_univ_yr_sem =
loc_instructor_bio.CODE_UNIV_YR_SEM)
WHERE (((loc_tcm.code_univ_yr_sem)="200607FA") AND
((loc_tcm.code_csec_loc)="UP" Or (loc_tcm.code_csec_loc)="XS") AND
((loc_tcm.code_csec_delivery)="R") AND
((loc_tcm.code_csec_cancel)<>"C") AND ((loc_tcm.code_csec_coll)="LA"));