Is it Possible to submit InfoPath forms to an Access DB on SharePoint?
Posted on 2012-04-12
We have InfoPath 2010, Access 2010 and SharePoint 2010 Enterprise
I need 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 right now, I just need to know if it is possible.
Here are the details of what we would like to do.
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.
Is this a strategy that will work?