SQL Query not updateable?

[CGSB]

Hi, I have a Recorset in Access which uses the following query:

SELECT course.course_name, candidate_course.status,   
       candidate_course.year, candidate_course.quarter, 
       candidate_course.file_no
FROM course LEFT JOIN candidate_course 
ON (course.course_id = candidate_course.course_id 
AND candidate_course.file_no = '77777')
WHERE course.set="1
ORDER BY course.course_name;

This query makes a Recordset that is not updateable.

I was wondering if there is another way I can format my statement so that it is updateable... unless the problem is with my database design (tables and relationships).

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886