Cannot Update View in ADP Form! help!

[Linda]

Hi,

Can someone tell me why i can't update a view in adp form. I upgraded
access 2000 to sql 7 first, then to sql 2000. The form calls a view
which has a simple sql statement such as this:

SELECT Comment_History_ID, Client_ID, Agent_ID, AsOfDate, Comment
FROM dbo.Comments_History

When i try to edit the view from adp it gives me this error: "THe
recordset is not updatable"



the strange thing is i have another view where i am calling a view and
i can update just fine, so i dont think its a problem with security.
The view has the with the following sql:

SELECT Client_Pmt_Date, Amt, MtgSvr_Pmt_Start_Date, PmtNum,
Amt_Paid_Date, PmtType_ID, Pmt_Schedule_ID, Loan_ID, Pmt_Comments,
AddDebitFee,
Amt_Comments, Return_Code
FROM dbo.Payments


Any idea of how i can fix this, i've tried EVERYTHING! thanks in
advance!

 

[Per Ove Steinsland]

Hi Linda.
Can you update the View "directly"?
(if you double click on the View is it updateable?)

If not then it could be that you have to add a PK to the table? (access
req.this)

If you can update the View then the problem is in the form. Check data
prop. on the form.
Unique table etc..

perove

 

[Linda]

Thanks Perove for your response. I found what the problem was. Somehow
after i upsized the database Comment_History didn't have a primary
key, and that prevents it from updating the view.

 

[Bruce Loving]

In an Access form, you must set the Unique Table property if a view
joins 2 or more tables.