Update SQL with Joinning a Read only view

[Stanley]

Hi there,

Here is my SQL in Access2000,

Update TableA inner join ViewA on TableA.AID = ViewA.AID
set TableA.A = ViewA.A, TableA.B = ViewA.B

My problem is that ViewA is a Read Only View that cannot be update.
Therefore, I cannot update TableA's fields with ViewA from the above SQL.

How should I write a SQL in Access 2000 to doing things like that?

Thanks in advance.

 

[Duane Hookom]

This will be slow but
Update TableA
Set A = DLookup("A","ViewA","AID=" & AID)
B=DLookup("B","ViewA","AID=" & AID);

This assumes the AID field is numeric. If not, you need to add in the
delimiters.

 

[Stanley]

Thx Duane.

So, I think I better not use SQL but do calculation in VB.