Survey forespørgsels fejl :-(

Nedenunder ses to forespørgsler. Mit problem er at min SQL forespørgsel virker fint, hvorimod kan jeg ikke få Access forespørgslen til at virke. Access forespørgslen viser ikke poster hvor SurveyQuestionType er tekst fordi de ikke har SurveyChoices tilknyttet. Hvad skal jeg gøre anderledes?
På forhånd tak.

SQL 7.0::
SELECT SS.ID AS [SectionID], SS.SectionName, SS.SectionOrder,
SQ.ID AS [QuestionID], SQ.QuestionOrder, SQC.ChoiceOrder,
SQC.ChoiceID, SQT.Value, SS.SectionDescription, SQ.Question, SC.ChoiceDescription
FROM Survey S
INNER JOIN SurveySection SS ON S.ID = SS.SurveyID
INNER JOIN SurveyQuestion SQ ON SS.ID = SQ.SectionID
LEFT OUTER JOIN SurveyQuestionChoice SQC ON SQ.ID = SQC.QuestionID
LEFT OUTER JOIN SurveyChoice SC ON SQC.ChoiceID = SC.ID
INNER JOIN SurveyQuestionType SQT ON SQ.QuestionTypeID = SQT.ID
WHERE S.ID = 6
ORDER BY SS.SectionOrder, SQ.QuestionOrder, SQC.ChoiceOrder


Access::
SELECT SurveySection.ID AS SectionID, SurveySection.SectionName, SurveySection.SectionOrder, SurveyQuestion.ID AS QuestionID, SurveyQuestion.QuestionOrder, SurveyQuestionChoice.ChoiceOrder, SurveyQuestionChoice.ChoiceID, SurveyQuestionType.Value, SurveySection.SectionDescription, SurveyQuestion.Question, SurveyChoice.ChoiceDescription
FROM Survey INNER JOIN (SurveySection INNER JOIN (SurveyQuestionType RIGHT JOIN (SurveyQuestion INNER JOIN (SurveyChoice INNER JOIN SurveyQuestionChoice ON SurveyChoice.ID = SurveyQuestionChoice.ChoiceID) ON SurveyQuestion.ID = SurveyQuestionChoice.QuestionID) ON SurveyQuestionType.ID = SurveyQuestion.QuestionTypeID) ON SurveySection.ID = SurveyQuestion.SectionID) ON Survey.ID = SurveySection.SurveyID
WHERE (((Survey.ID)=6))
ORDER BY SurveySection.SectionOrder, SurveyQuestion.QuestionOrder, SurveyQuestionChoice.ChoiceOrder