[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Infopath: linking certain text boxes to an Access database

Posted on 2012-09-19
Medium Priority
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:Murray Brown
LVL 28

Accepted Solution

clayfox earned 2000 total points
ID: 38413321
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.

Www.qdabra.com has examples of what is possible with a true enterprise solution.

Author Closing Comment

by:Murray Brown
ID: 38414131
Thanks very much for the information

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

872 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