General discussion

Locked

Is it possible to use InfoPath to send data to/from Access on SharePoint?

By clark ·
We have InfoPath 2010, Access 2010 and SharePoint 2010 Enterprise

I would like to know if it is possible to use InfoPath to submit forms to an access DB on SharePoint.

I don???t need to know how to do this, I just need to know if it is possible.

Here are the details of what we are thinking.

We need this for employee leave and benefit tracking. Currently we are using a complicated Excel workbook to do part of this.

What I would like to do is:

have an access database that holds the following:

a. Employee information (contact info, date started, training info, job description etc)

b. Leave earned (Overtime, Sick, Vacation)

c. Leave taken (overtime, sick, vacation)

d. Leave that can be advanced (usually vacation you could earn between now and the end of the fiscal year)

e. Available leave (overtime, sick, vacation)

f. Available benefits (health, education)

g. Benefits used (health, education)

h. Generate reports corporate wide on the above

We would like to have InfoPath forms that do the following:

a. When the form is opened from sharepoint, based on ID of logged in user, populate the form with some of the employee information, and the leave/benefits available

b. Have place in the form to apply for leave (date range and leave type)

c. Use a workflow to submit the form to a supervisor

d. Supervisor approval gets forwarded to HR

e. HR approval sends approval or deny to staff and submits the leave (dates and type) to the access DB and applies it to that employees leave.

I also need HR to have the ability to override some of the InfoPath information that is submitted to Access. (ie. If date range for leave includes weekends, holidays or any other office closure those days need to be deducted from the leave taken)

I would like all this to be handled via SharePoint and Ideally, the logged in user would have access to all their own data so they could see all their available leave, leave taken, benefits used etc.

Do you think this a strategy that will work?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Try reposting as Q&A

Try re-posting in the Q&A
section.The 'Discussion' forum is for matters of general discussion, not specific problems in search of a solution. The 'Water Cooler' is for non-technical discussions. You can submit a question to 'Q&A' here:

http://www.techrepublic.com/forum/questions/post?tag=mantle_skin;content

There are TR members who specifically seek out problems in need of a solution. Although there is some overlap between the forums, you'll find more of those members in 'Q&A' than in 'Discussions' or 'Water Cooler'.

Be sure to use the voting buttons to provide your feedback. Voting a '+' does not necessarily mean that a given response contained the complete solution to your problem, but that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours. If they have a ready source of reference available, perhaps won't need to repeat questions previously asked and answered. If a post did contain the solution to your problem, you can also close the question by marking the helpful post as "The Answer". . .

Collapse -

Thank you

by clark In reply to Is it possible to use Inf ...

thank you for the info on using TR. Much appreciated. I'll repost.

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums