Is it possible to connect to an Access database [to send data] after starting with a Blank Form Template? - InfoPath Dev
in

InfoPath Dev

Is it possible to connect to an Access database [to send data] after starting with a Blank Form Template?

Last post 04-23-2011 03:45 PM by Skarn. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-23-2011 10:28 AM

    Is it possible to connect to an Access database [to send data] after starting with a Blank Form Template?

    I hope this is somehow possible.

    Thanks

  • 04-23-2011 03:45 PM In reply to

    • Skarn
    • Top 50 Contributor
      Male
    • Joined on 04-20-2008
    • Australia
    • Posts 198

    Re: Is it possible to connect to an Access database [to send data] after starting with a Blank Form Template?

    You can use ImportXML VBA command it import XML forms into Access.

    Each group becomes a table and each field a field in that table.

    You might instead be able to use VBScript/JScript and use DAO or ADO connection methods.

    But I'm pretty sure that you can't connect the primary datasource of an Infopath form to a database after the fact - it has to be created from the beginning as using the database as it's primary datasource.

     

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.