Solved

InfoPath Basics

Posted on 2011-02-15
8
410 Views
Last Modified: 2012-05-11
I've never used InfoPath before and am wondering if it's the right product for this:
I want users to be able to edit an attractive form through SharePoint 2.0 and then store/link the data entered in the form in an Access database.  Is InfoPath the best way to do this?  Any issues?
0
Comment
Question by:error_prone
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 2

Accepted Solution

by:
siteoutfitters earned 500 total points
ID: 34903160
This type of setup would play off the strengths of both products.  Here's a basic sample of how to set it up in case you were looking for the "next" step:
http://office.microsoft.com/en-us/infopath-help/how-to-guide-connecting-an-infopath-form-to-an-access-database-HA001119950.aspx
0
 

Author Comment

by:error_prone
ID: 34903164
What about the SharePoint piece?  I want users to be able to access this form through SharePoint.  Once the form opens through SharePoint will the it work just the same?  Also, our company is still using SharePoint 2.0 - will that cause a problem?
0
 
LVL 2

Expert Comment

by:siteoutfitters
ID: 34903179
Once you build the Form in InfoPath you can publish it to SharePoint.  The 2.0 version should allow this.  Here's a quick set of steps, just be sure to follow the proper sections based on your InfoPath version.  I hope this helps you out!
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 

Author Comment

by:error_prone
ID: 34903185
Were there additional steps you were going to write?  Reading your last post....
Thanks for your help, BTW.  I'm glad InfoPath will work for what I am trying to do, plus the steps look pretty straight-forward.
0
 
LVL 2

Expert Comment

by:siteoutfitters
ID: 34903194
terribly sorry on this miss-post:
http://support.microsoft.com/kb/826993

I think this is what you need.
0
 

Author Comment

by:error_prone
ID: 34903205
This says how to submit the form data to SharePoint as a list item.  I just want the entire form to be accessible through SharePoint and then submit the data back to Access.  That will work, right?
0
 

Author Closing Comment

by:error_prone
ID: 34903211
I think this will work, thanks!
0
 
LVL 2

Expert Comment

by:siteoutfitters
ID: 34903217
Yes, it will publish the form into SP for use via the web, I think it's the right track for your request...but as always, good luck with the real-world mileage.
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

636 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