Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Infopath Submitted to Sharepoint Then Sent to Access Database

Posted on 2013-10-25
10
Medium Priority
?
826 Views
Last Modified: 2013-11-15
I have an Infopath (2007) form that I would like users to submit to a Sharepoint site but I would like the person processing the form to then send the information to an Access database. Is this possible? If so would is it also possible to add some kind of code in the form that once its processed then its deleted fromthe sharepoint site?
0
Comment
Question by:spaced45
[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
  • 6
  • 4
10 Comments
 
LVL 28

Expert Comment

by:clayfox
ID: 39601184
If the users have InfoPath, you could build the form as a database type against the Access Table. (does not work with a browser form)
You could publish it to SharePoint but they would need the Access Database on a public share so that InfoPath could submit to it.

http://sharepoint-videos.com/open-sharepoint-list-data-with-access/ looks like if you submit to the SharePoint library that it is possible to link Access to the list.
http://office.microsoft.com/en-us/access-help/import-from-or-link-to-a-sharepoint-list-HA001230313.aspx

The deletion and clean up would have to be handled separately.

Best Practice would be to use SQL or even SQL express instead.  You could then build another InfoPath form that would replace the Access Forms and be more performant and shareable/reportable with your enterprise.
0
 
LVL 1

Author Comment

by:spaced45
ID: 39601325
Clayfox,
Thank you for your assistance. Yes, I think doing this in SQL would be best but I do not have the needed rights to build a SQL database. My first attempt was to submit directly to Access which was not a problem. Where I ran into a problem was that I wanted to query for different informaiton within the same database but different table. I actually submitted a previous question that lead to this one. Here is the link:
 http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Infopath/Q_28274264.html
0
 
LVL 1

Author Comment

by:spaced45
ID: 39601333
I forgot to add this. Another important reason for me wanting to do this is the terrible response time when Infopath forms interact with access over a network.
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 28

Accepted Solution

by:
clayfox earned 2000 total points
ID: 39601346
Yah, hence why Access is not the ideal solution. It is not the backend for any kind of enterprise solution with more than one user.

I have gotten around some of the query issue by relating tables.

Have a parent and then child tables with keys and relations.

That has allowed me to query multiple loosely related child tables.

Just setup a SQL express instance on your computer or some dedicated box.

Another option possibly is formsboard.com which is a hosted solution by www.qdabra.com

they will host the form and give you the backend database and everything if you are in a hostile IT environment.

Another option is to keep your data in SharePoint lists as long as it is not too big.
0
 
LVL 28

Expert Comment

by:clayfox
ID: 39601350
Another trick I thought of was I have used multiple forms in combination.

Main form works on the main table and then when they drill in I open a second form and pass the record ID and it opens and queries the second table, etc.
When they are done it closes and they are back to the first.
0
 
LVL 1

Author Comment

by:spaced45
ID: 39602168
YES! I actually considered that as a possible solution. Using one form as a mean of displaying queried information and passing information to another form connected to the database to actually submit or process the information. Great! We are on the same wave length. Here is some additional info that might be able to focus the ideas.

I've been tasked in creating a vaction request process. I have done this before in Access but for a small dept of about 100. Now they are asking that I build something for 300 extra employees. The Access database really is a means of storage. I hate having to use it but they are asking me to make wine out of water here so I have no choice. My goal is to have the users have as little interaction with the DB as possible. Here was my idea now that I know we are speaking the same language.

Employee opens form 1 that is strickly a means of information. For example I would connect a DB query showing them their vacation time summary, taken vaction records and so forth. All of the queries have been already made and I can filter with no problem based on userid. The second form would be the actual form used to submit the information to the DB table holding all the records. Here is a perfect example for you. Employee opens form, they see available dates and then they make the choice. First form then opens second form, first form passes the info over to second form and submits to DB.

Great ideas. Thank you for your assistnace so far.
0
 
LVL 1

Author Comment

by:spaced45
ID: 39613160
Ummm... I hope I didn't freak anyone out with to much info so if I did I will get back to the barebones.

How can I pass data from one infopath form to another? Forget all the details. Thanks and sorry for all the over enthusiasm.
0
 
LVL 28

Expert Comment

by:clayfox
ID: 39613318
Sorry, did not get back to this one.

you would use the xdocument function to reference the InfoPath forms.

I believe there are samples of jscript and VB on www.infopathdev.com

I will see if I can harvest some code out of mine as well.
0
 
LVL 1

Author Comment

by:spaced45
ID: 39615822
that would be great! Thank you again.
0
 
LVL 1

Author Closing Comment

by:spaced45
ID: 39651843
Very helpfult
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

670 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