Update SQL with Joinning a Read only view

  • Thread starter Thread starter Stanley
  • Start date Start date
S

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.
 
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.
 
Back
Top