Posted on 1998-02-17
I don't get it :
I have a query with 3 joined tables.
I want to let the user be able of modifying 3 fields of one of these tables. (Use, Checked, Remarks)
To make my query 'live', I use a TupDateQuery with the following modifying sql :
RemarkSite = :RemarkSite,
Use = :Use,
Checked = :Checked
qcmSite = :OLD_qcmSite and
Measure_Date = :OLD_Measure_Date and
Measure_Time = :OLD_Measure_Time
I set the UpdateObject of the query to my update object.
I then make my table active and it still says that my table is read-only!!!
Can somebody help me with this one?
Forgot to mention, I use an Access database with ODBC driver