I have write a query which works very fine in access but when i am trying to run it through Data Environment it through a runtime error:

Run-time error '-2147467259 (80004005)':
Relate, Compute By, and Sort operations cannot be performed on column(s) whose defined size is unknown or too large.

Here is the Query;

SELECT PatientTbl.PatientId, PatientTbl.PatientName, PatientTbl.ADDRESS, PatientTbl.AGE, PatientTbl.Sex, TestGroupMasterTbl.GroupNo, TestMasterTbl.LabNo, TestMasterTbl.TestDate, TestMasterTbl.PatientType, TestMasterTbl.BedNo, TestMasterTbl.TokenAdNo, TestMasterTbl.DoctorId, TestMasterTbl.DepartmentId, TestMasterTbl.TimeOfCollection, TestMasterTbl.TimeOfTest, TestMasterTbl.ConsultantId, ConsultantTbl.Name, ConsultantTbl.Degree, TestListTbl.TestNo, TestListTbl.Test, TestListTbl.NormalRange, TestDetailGroupTbl.Specimen, TestDetailTbl.Value, TestGroupMasterTbl.CategoryNo, TestGroupDetailTbl.SubCategoryNo
FROM TestListTbl INNER JOIN ((TestGroupMasterTbl INNER JOIN (PatientTbl INNER JOIN ((ConsultantTbl INNER JOIN TestMasterTbl ON ConsultantTbl.ConsultantId = TestMasterTbl.ConsultantId) INNER JOIN (TestDetailTbl INNER JOIN TestDetailGroupTbl ON TestDetailTbl.GroupNo = TestDetailGroupTbl.GroupNo) ON (TestMasterTbl.LabNo = TestDetailTbl.LabNo) AND (TestMasterTbl.LabNo = TestDetailGroupTbl.LabNo)) ON PatientTbl.PatientId = TestMasterTbl.PatientId) ON TestGroupMasterTbl.GroupNo = TestDetailGroupTbl.GroupNo) INNER JOIN TestGroupDetailTbl ON TestGroupMasterTbl.GroupNo = TestGroupDetailTbl.GroupNo) ON (TestListTbl.TestNo = TestGroupDetailTbl.TestNo) AND (TestListTbl.TestNo = TestDetailTbl.TestNo)
WHERE (((TestMasterTbl.LabNo)=[?]));


Please help;
Wasim Zafar