Cannot Update View in ADP Form! help!

  • Thread starter Thread starter Linda
  • Start date Start date
L

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!
 
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
 
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.
 
In an Access form, you must set the Unique Table property if a view
joins 2 or more tables.
 
Back
Top