I have Sharepoint Server 2007 installed on my server running SBS 2003. I have a Sharepoint Site that is up and running, sharing documents and other basic functions over the internet. I have Infopath 2007.
I have read "How to's" on deploying a InfoPath form in Sharepoint. I identified myself as a beginner. I used that because there wasn't a lower item in the combo box.
I need to get my thoughts around on how to get a form up and running in Sharepoint.
I created an Access database on the server. I want to be able to store the data from the form. When I try to create a new form, it has Access grayed out. With SBS 2003, I have SQL Server on there, but I don't know how to create the SQL DB. The books indicate Access is OK. By the way, the database is 2 tables, Owner and Details.
If I can resolve this, I open Infopath, link to the DB as a data source and then organize the fields on the form. I have played with it. I don't pretend to understand it. I have created detailed forms and reports in Access.
I understand I create my InfoPath form and then save it and then publish it to the Sharepoint site. I want to put it in a library so it can be used over and over, with the data saved on the server. Do I need special buttons on the form to save and clear?
I am sure that I am missing many steps and I am looking for direction. Thank you
Start Free Trial