I am trying to make sense of the Sage Line 50 accounts package through
Access 2k
I have linked the tables and they appear OK

The following query runs OK

SELECT AUDIT_JOURNAL.NOMINAL_CODE, AUDIT_JOURNAL.ACCOUNT_REF,
NOMINAL_LEDGER.NAME, PURCHASE_LEDGER.NAME
FROM (AUDIT_JOURNAL INNER JOIN NOMINAL_LEDGER ON AUDIT_JOURNAL.NOMINAL_CODE
= NOMINAL_LEDGER.ACCOUNT_REF) INNER JOIN PURCHASE_LEDGER ON
AUDIT_JOURNAL.ACCOUNT_REF = PURCHASE_LEDGER.ACCOUNT_REF;

but if I change the equal join between the Audit_Journal and the Purchase
ledger from an inner join to a left join thus

SELECT AUDIT_JOURNAL.NOMINAL_CODE, AUDIT_JOURNAL.ACCOUNT_REF,
NOMINAL_LEDGER.NAME, PURCHASE_LEDGER.NAME
FROM (AUDIT_JOURNAL INNER JOIN NOMINAL_LEDGER ON AUDIT_JOURNAL.NOMINAL_CODE
= NOMINAL_LEDGER.ACCOUNT_REF) LEFT JOIN PURCHASE_LEDGER ON
AUDIT_JOURNAL.ACCOUNT_REF = PURCHASE_LEDGER.ACCOUNT_REF;

I get an error
"Could not execute query, could not find linked table Table not found
(#0)"

However this query runs OK

SELECT AUDIT_JOURNAL.NOMINAL_CODE, AUDIT_JOURNAL.ACCOUNT_REF,
PURCHASE_LEDGER.NAME
FROM AUDIT_JOURNAL LEFT JOIN PURCHASE_LEDGER ON AUDIT_JOURNAL.ACCOUNT_REF =
PURCHASE_LEDGER.ACCOUNT_REF;

Any ideas please

Thanks

Phil

"Phil Stanton" <phil@myfamilyname.co.ukwrote in message
news:c4idnQbd6KBa3F_VnZ2dnUVZ8t7inZ2d@posted.plusn et...

>I am trying to make sense of the Sage Line 50 accounts package through
>Access 2k
I have linked the tables and they appear OK
>
The following query runs OK
>
SELECT AUDIT_JOURNAL.NOMINAL_CODE, AUDIT_JOURNAL.ACCOUNT_REF,
NOMINAL_LEDGER.NAME, PURCHASE_LEDGER.NAME
FROM (AUDIT_JOURNAL INNER JOIN NOMINAL_LEDGER ON
AUDIT_JOURNAL.NOMINAL_CODE = NOMINAL_LEDGER.ACCOUNT_REF) INNER JOIN
PURCHASE_LEDGER ON AUDIT_JOURNAL.ACCOUNT_REF =
PURCHASE_LEDGER.ACCOUNT_REF;
>
but if I change the equal join between the Audit_Journal and the Purchase
ledger from an inner join to a left join thus
>
SELECT AUDIT_JOURNAL.NOMINAL_CODE, AUDIT_JOURNAL.ACCOUNT_REF,
NOMINAL_LEDGER.NAME, PURCHASE_LEDGER.NAME
FROM (AUDIT_JOURNAL INNER JOIN NOMINAL_LEDGER ON
AUDIT_JOURNAL.NOMINAL_CODE = NOMINAL_LEDGER.ACCOUNT_REF) LEFT JOIN
PURCHASE_LEDGER ON AUDIT_JOURNAL.ACCOUNT_REF =
PURCHASE_LEDGER.ACCOUNT_REF;
>
I get an error
"Could not execute query, could not find linked table Table not found
(#0)"
>
However this query runs OK
>
SELECT AUDIT_JOURNAL.NOMINAL_CODE, AUDIT_JOURNAL.ACCOUNT_REF,
PURCHASE_LEDGER.NAME
FROM AUDIT_JOURNAL LEFT JOIN PURCHASE_LEDGER ON AUDIT_JOURNAL.ACCOUNT_REF
= PURCHASE_LEDGER.ACCOUNT_REF;
>
Any ideas please
>
Thanks
>
Phil

PS Seems to work OK If I Import tables rather than linking them

>