Link to home
Start Free TrialLog in
Avatar of Peter Chan
Peter ChanFlag for Hong Kong

asked on

Problem to update

I get error like

It should be updateable query

due to this

UPDATE [DTP Cost] SET [DTP Cost].[AE_503-101] = (SELECT Sum([DTP Expenditure].[503-101-Study-Grant]) FROM [DTP Expenditure])
WHERE [DTP Cost].[Course Code]='PDT020150004I';

Open in new window

within Access. Why?
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

The only time I have seen that error is when the database file is read only.  Enable write permissions.
Can you prepare sample DB?
Avatar of als315
Flag of Russian Federation image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial