Infopath Form, Access DB, Sharepoint

[bacosta82]

Hello.

I am looking to creat a web based form that will be hosted on our
sharepoint site. I would like to have the users fill out and submit
this form into a MS Access DB via a button on the form. Right now I
have the form in a document library and when users save the form I
have to go in behind them and manually input the data the submitted
into a excel spreadsheet. Also, not all users can fill out the form b/
c they only have Office XP (no infopath).

Can someone walk me thru the steps of having this form web based so
all users can fill out and how to build a data connection to an Access
DB? Maybe there is a article out on the web, but I could not find.

Thanks for any help!!!!!

 

[Developer]

Hi,

1. You must configure InfoPath Forms Services in Microsoft Office SharePoint
Server (Enterprise). This will make it possible for your users to fill out
InfoPath forms in a Web browser.

The article here - http://technet.microsoft.com/en-us/library/cc262263.aspx
- on configuring IPFS for MOSS should help.

2. Certain controls are not available in Browser-enabled forms so, for
starts, you may open your form in design mode and on the InfoPath client menu
click Tool > Form Options > Compatibility > (Browser compatibility) Design a
form template that can be opened in a browser or Infopath. Once you click
'Ok' you should be presented with issues that exist with the form in the
Design Checker.

Sort out the issues presented.

3. For connections to Access from a browser-enabled form, you would need to
write a web service

4. Work through the Labs at
http://msdn.microsoft.com/en-gb/library/bb877921.aspx to continue.