Edit the Results of an Access Join Query

Posted on 2011-10-26
Last Modified: 2012-08-13
I have two tables that exist in a MySQL Database, that are connected to my
Access Application over an ODBC connection, which is linked.

I want to be able to join together two tables in a query and edit the results.

FROM Fileroom AS fr 

LEFT JOIN fin_prod AS fn 

Open in new window

The CIS Account ID is unique in both cases, however;
1 might have more than the other. Is it possible to edit
the results of this query?
Question by:JustinW
    LVL 1

    Author Comment

    Figured it out;
    Changed the Joined Fields (cis_account_id) to a primary key in both tables
    LVL 119

    Accepted Solution

    see this link for possible solution

    When can I update data from a query
    LVL 77

    Expert Comment

    I don't really understand why you ask the question here rather than just trying it?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now