troubleshooting Question

Access Message: Operation must use an updateable Query

Avatar of LFreehauf
LFreehauf asked on
Microsoft AccessSQL
2 Comments1 Solution609 ViewsLast Modified:
Objective:  Update table dbo_LEASEBUT4 based on a value in table dbo_LEASEBUT7
The following Syntax::
update dbo_LEASEBUT4 set dbo_LeaseBut4.leasid = (select dbo_LeaseBut7.leasid from dbo_Leasebut7 where  dbo_LeaseBut7.HCode=dbo_LeaseBut4.HCode) where Exists(select * from dbo_LeaseBut7 where dbo_LeaseBut7.HCode=dbo_LeaseBut4.HCode)
Result: Returns the following error:  "Operation must use an Updateable Query"

Note 1:
To test/eliminate the issue of the table being "updatable", the following ran successfully:
update dbo_LeaseBut4 set dbo_LeaseBut4.leasid = 100011
Result:  All rows updated with 100011 as expected

Note 2:
Further testing, the following ran successfully:
update dbo_LeaseBut4 set dbo_LeaseBut4.leasid = dbo_Leasebut4.tfinrepsup
Result:  All rows updated with the value from field dbo_Leasebut4.tfinrepsup

Note 3: Other info (for what it's worth):
No queries exist (Only tables)
I do not believe the tables have groups, sums, etc.  I checked/double checked.
They are Access tables (imported from MS-SQL DB).  The Access tables are no longer linked.
The update syntax is from Experts-Exchange solution 2/4/2005; BigSchmuh; Solution ID: 13225084
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros