Hi there
I have a form which hold its data in form of a query which the user manipulates. In the form there is a calculate button that runs through a series of steps, one is a sql command as below:
UPDATE tblcurriculum0203 LEFT JOIN tblDLNBR ON tblcurriculum0203.acad_period = tblDLNBR.DLAcad_period SET tblcurriculum0203.GLH = [DLGLH]
WHERE (((tblDLNBR.DLProgWeightA)=[Forms]![FrmCourse]![rate_fixed]) AND ((tblDLNBR.DLAcad_period)=[Forms]![FrmCourse]![acad_period]) AND ((tblcurriculum0203.[Course Code])=[Forms]![FrmCourse]![FindCourseCode]));
It asks me if I want to update 1 row I click Yes and it says could not update due to lock violations. Can I turn this off somewhere???
I find other SQL commands which update in this way are OK. I've tried inserting the save record command before and after the statement and various other places.
Can anyone please help??
I have a form which hold its data in form of a query which the user manipulates. In the form there is a calculate button that runs through a series of steps, one is a sql command as below:
UPDATE tblcurriculum0203 LEFT JOIN tblDLNBR ON tblcurriculum0203.acad_period = tblDLNBR.DLAcad_period SET tblcurriculum0203.GLH = [DLGLH]
WHERE (((tblDLNBR.DLProgWeightA)=[Forms]![FrmCourse]![rate_fixed]) AND ((tblDLNBR.DLAcad_period)=[Forms]![FrmCourse]![acad_period]) AND ((tblcurriculum0203.[Course Code])=[Forms]![FrmCourse]![FindCourseCode]));
It asks me if I want to update 1 row I click Yes and it says could not update due to lock violations. Can I turn this off somewhere???
I find other SQL commands which update in this way are OK. I've tried inserting the save record command before and after the statement and various other places.
Can anyone please help??
