Peter Chan
asked on
Problem to update
Hi,
I get error like
It should be updateable query
due to this
within Access. Why?
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';
within Access. Why?
The only time I have seen that error is when the database file is read only. Enable write permissions.
Can you prepare sample DB?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.