Update Table use Left outer join in ms acces

25 pts.
Tags:
microsoft acces
hello, i wont to ask i try to update table use from another table, i sue the left outer join if in ms sql server this command is run, but when i try to in ms acces its cant run please see the command Private Sub Command31_Click() Dim update_personallog As Integer update_personallog = "update personallog set personallog.username= employee_master.user " _ & " from personallog left outer join employee_master " _ & "on personallog.fingerprintid = employee_master.fingerprintid " DoCmd.RunSQL update_personal End Sub

Answer Wiki

Thanks. We'll let you know when a new response is added.

I think the syntax in Access is different.

Try something like this:

<pre>update_personallog = “update personallog left outer join employee_master ” _
& ” on personallog.fingerprintid = employee_master.fingerprintid ” _
& ” set personallog.username= employee_master.user ” _
</pre>

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Wahyono
    still cant, any body know abaut this. please help me
    25 pointsBadges:
    report
  • carlosdl
    What is the error message you are getting ? There is an extra "_" at the end of the third line in the answer above, did you remove it ?
    69,175 pointsBadges:
    report
  • Wahyono
    there is msg pls see Run-time error '3075': syntax error(missing operator) in query expresion 'employee_master.user from personallog left outer join employee_masteron personallog.fingerprintid= employee_master.fingerprintid".
    25 pointsBadges:
    report
  • carlosdl
    There is a blank space missing before the ON keyword in the JOIN. The resultant query should look like this:
    employee_master.user from personallog left outer join
    employee_master on personallog.fingerprintid=
    employee_master.fingerprintid.
    I would suggest to test the query directly in access, and when you are able to run it without errors there, you modify your VB application to construct the query in the correct way. Regards,
    69,175 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following