Hello! I am new to running queries in Access and this one will not run with a 360 timeout. I even tried the 720 timeout with no success. Here is the query and the error.

SELECT Count('x') AS KJoinRecCnt
FROM ((PROD_VRBL_CMPNT INNER JOIN K_PROD_VRBL_CMPNT ON
(PROD_VRBL_CMPNT.SEQ_NO = K_PROD_VRBL_CMPNT.SEQ_NO)
AND (PROD_VRBL_CMPNT.EFF_DT_SK = K_PROD_VRBL_CMPNT.EFF_DT_SK)
AND (PROD_VRBL_CMPNT.TIER_NO = K_PROD_VRBL_CMPNT.TIER_NO)
AND (PROD_VRBL_CMPNT.PROD_ID = K_PROD_VRBL_CMPNT.PROD_ID)
AND (PROD_VRBL_CMPNT.PVC_SK = K_PROD_VRBL_CMPNT.PVC_SK))
INNER JOIN CD_MPPNG ON (CD_MPPNG.SRC_CD = K_PROD_VRBL_CMPNT.SRC_SYS_CD)
AND (PROD_VRBL_CMPNT.SRC_SYS_CD_SK = CD_MPPNG.CD_MPPNG_SK))


INNER JOIN CD_MPPNG AS CD_MPPNG_1 ON (CD_MPPNG_1.SRC_CD = K_PROD_VRBL_CMPNT.PVC_TYP_CD)
AND (PROD_VRBL_CMPNT.PVC_TYP_CD_SK = CD_MPPNG_1.CD_MPPNG_SK);

and the error

I get an SQL0952N Proccessing was cancelled due to an interrupt.

Thank you!

Karla