Access 2002 vs 2007

[ispstan]

we use an Access db created in Access 2002 file format, residing on
SmBusServer 03. We installed a new workstation w/Office Pro 2007 which opens
the db in the 07 format and doesn't recognize some functions of the 2002
version. Suggestions? Thanks.

 

[ispstan]

to be more specific: a form field is sorted alphabetically by the following:
SELECT DISTINCTROW tblPatient.[ISPID#], tblPatient.PatientName,
tblPlan.PlanName, tblDoctor.DoctorLastName, tblPatient.Location FROM tblPlan
INNER JOIN (tblDoctor INNER JOIN tblPatient ON tblDoctor.DoctorID =
tblPatient.DoctorID) ON tblPlan.PlanID = tblPatient.Pln ORDER BY
tblPatient.PatientName, tblPlan.PlanName;

However, when I open this form on the 2007 computer the field finds no
records at all unless I remove the portion "tblPatient.PatientName" from the
ORDER BY sentence. Then the records are found, but won't sort.

 

[Mark A. Sam]

Assuming this is the sql for the form's RecordSource, did you try opening it
in query designiew in A2007? If there is an error is should inform you. If
it opens you should be able to inspect the query for design flaws. I don't
know why it won't run, but that is a place to start.

God Bless,

Mark A. Sam

to be more specific: a form field is sorted alphabetically by the
following:
SELECT DISTINCTROW tblPatient.[ISPID#], tblPatient.PatientName,
tblPlan.PlanName, tblDoctor.DoctorLastName, tblPatient.Location FROM
tblPlan
INNER JOIN (tblDoctor INNER JOIN tblPatient ON tblDoctor.DoctorID =
tblPatient.DoctorID) ON tblPlan.PlanID = tblPatient.Pln ORDER BY
tblPatient.PatientName, tblPlan.PlanName;

However, when I open this form on the 2007 computer the field finds no
records at all unless I remove the portion "tblPatient.PatientName" from
the
ORDER BY sentence. Then the records are found, but won't sort.
--
ispstan

we use an Access db created in Access 2002 file format, residing on
SmBusServer 03. We installed a new workstation w/Office Pro 2007 which
opens
the db in the 07 format and doesn't recognize some functions of the 2002
version. Suggestions? Thanks.