Prev: Only where a specific feild is unique.
Next: Difference between fields in query
From: John on 24 Feb 2010 03:23
The error message in Access is:

Operation must use an updatable query




John Carter wrote:

Bug in Access - Update with subquery
24-Feb-10

In SQL*Server, this works:

use jc1accts
update customer
set balance =
(select sum(amount)
from invoice
where customer.c_no = invoice.c_no)

In Access, you get this error:

"Operation must use an updatable query"

This clearly illustrates a bug in Access.

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint List Usage and Statistics
http://www.eggheadcafe.com/tutorials/aspnet/892bae83-5b96-4275-95fd-9723a79fdb14/sharepoint-list-usage-and.aspx
 | 
Pages: 1
Prev: Only where a specific feild is unique.
Next: Difference between fields in query