want update view but update table

want update view but update table

Post by QuickFo » Thu, 18 Jan 2001 10:39:37



Dear all,

Please help !!!

on SQL Server 7, I have a view , ViewA that select from a table TableA

on VFP 6, a ADO(2.5) Recordset ,RS use source "Select * from ViewA order by
keyid desc".

When I run Update method,  it tell me access denied for update TableA.

why ADO select from ViewA, but update/insert from TableA.