Infopath Form, Access DB, and Sharepoint

[barocky]

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!!!!!

 

[Paresh]

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 aMS
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!!!!!

Hi,

Please take a look at the following links:
http://weblog.vb-tech.com/nick/archive/2007/01/17/2100.aspx
http://msdn.microsoft.com/en-us/library/bb979620.aspx

Do let me know, if you need any further information.

Thanks,
Paresh
http://www.openzeas.com/blogs/Paresh

 

[Harikrishna]

Hi,

To make the form Browser enable follow the steps given below:
Open the form in design mode.
Click Tools > Form Options > Compatibility > (Browser compatibility)
Design a form template that can be opened in a browser or Infopath and make
sure that all the controls support browser enabled form using Design Checker.

To Submit data to Access DB take a main data connection while designing form
and select the db to which the has to be submited.
Use the link to create data connection:
http://blogs.msdn.com/infopath/archive/2007/03/21/infopath-data-connections-part-1.aspx