InfoPath To MS Access - writing data RRS feed

  • Question

  • I plan to retrieve MS Access data in InfoPath using SQL. But based on what I read, if SQL query has JOIN then I cannot write back to the tables. Is there a solution around this. Thanks a lot.


    Thursday, September 20, 2012 10:12 PM


  • Hi Mayank,

    Yes, data using join query cannot write back directly. So please use custom code to analyze data and update it back.<//span>

    Thanks & Regards,
    Emir Liu
    TechNet Subscriber Support in forum
    If you have any feedback on our support, please contact tnmff@microsoft.com

    Emir Liu

    TechNet Community Support

    • Marked as answer by Emir Liu Thursday, September 27, 2012 3:09 AM
    Friday, September 21, 2012 6:42 AM