by I have a problem that is driving me nuts. I have been porting a VB3 app to
VB5 (Enterprise edition) and the following
query will pull an error when executed on the open database. Running the
exact query in access (2.0) on the same database
works fine. Is there something that I am missing? Please help.
This is the query in question:
UPDATE DISTINCTROW ((((ACCT_PRF_READ LEFT JOIN ACCT_PRF ON
ACCT_PRF_READ.ACCT_ICN = ACCT_PRF.ACCT_ICN) LEFT JOIN COMMON ON
ACCT_PRF.AP_FREQ = COMMON.ICN) LEFT JOIN ACCT_PRF_DIM ON ACCT_PRF.ACCT_ICN
= ACCT_PRF_DIM.ACCT_ICN) LEFT JOIN COMMON AS COMMON_1 ON
ACCT_PRF.AP_STR_TYPE = COMMON_1.ICN) LEFT JOIN COMMON AS COMMON_2 ON
ACCT_PRF_DIM.ACV_CODE = COMMON_2.CODE SET ACCT_PRF_READ.FREQUENCY =
[COMMON].[CONFIRM], ACCT_PRF_READ.TYPE = [COMMON_1].[CONFIRM],
ACCT_PRF_READ.VOLUME = [COMMON_2].[CONFIRM], ACCT_PRF_READ.SEQUENCE =
[COMMON].[SEQUENCE];
Chris Wagner
Fastech, Inc.