Infopath: linking certain text boxes to an Access database

Posted on 2012-09-19
Last Modified: 2012-09-19

I have been given an Infopath form with around 80 text boxes
and other controls on it.
I need only ten of the text boxes to go through to Access. What is the best way to do this.
I have managed to use the wizard to build a new form on based on an Access table,
but how do I link an existing InfoPath form to 10 Access fields so that the InfoPath
form can be used anywhere on the network and still goes to the same database?

Is VBA best or is there a wizard approach?
Question by:murbro
    LVL 28

    Accepted Solution

    First, a database form has to be created from scratch, meaning you cannot make a form a database form later. You will have to recreate the form.

    I would put all of the fields in the database, even if you only care about 10.

    Also my recommendation would be to use SQL or SQL express rather than Access. Development would be the same but performance is much better for multiuser solution.

    if you use a database then you could look at web services which is the better, more flexible method of storing data that it sounds like you want. has examples of what is possible with a true enterprise solution.

    Author Closing Comment

    Thanks very much for the information

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    746 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

    14 Experts available now in Live!

    Get 1:1 Help Now