[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Update query based on a query

Posted on 2006-11-09
3
Medium Priority
?
325 Views
Last Modified: 2012-08-13

Good afternoon Experts,

I am working with MS Access 2000.

There is a field called Requestors in a table called Tbl_Credit_Requests.
I need to change the values in this field from the user id to the persons first and last name.
The first and last name will come from Tbl_Employee.
Below is my sql:

Update Tbl_Credit_Requests

Set Requestor = (SELECT E.F_Name  & " " &  E.L_Name As Requestor2 FROM Tbl_Emp AS E where E.UserId = Tbl_Credit_Requests.Requestor)

Unfortunately, I get an error that states, “Operation must use an updateable query.”

Any advise is greatly appreciated.

Thank you,
0
Comment
Question by:TylerDerden
3 Comments
 
LVL 7

Expert Comment

by:rohanbairat3
ID: 17907845
What front end are you using

Check if you have permissions on the mdb file

http://databases.aspfaq.com/database/how-do-i-solve-operation-must-use-an-updateable-query-errors.html
0
 
LVL 77

Accepted Solution

by:
peter57r earned 1000 total points
ID: 17907977
Hi TylerDerden,

 Update Tbl_Credit_Requests inner join  Tbl_Emp as E
On  E.UserId = Tbl_Credit_Requests.Requestor
Set Requestor =E.F_Name  & " " &  E.L_Name

I am assuming that you have ensured that the UserID field is a text field of sufficient size to hold the name.


Pete
0
 

Author Comment

by:TylerDerden
ID: 17908171

rohanbairat3,

Sorry I should have posted this specifically under MS Access.

peter57r,

Yes, I did thank you. Worked like a charm.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question