InfoPath Dev

 Hi i ve a form which submits data to sharepoint lists and i ve written a code for the same which will work only if i give full control in Securty and trust category of Form options or else it will give an error"A first chance exception of type 'System.Security.SecurityException' occurred in Microsoft.Office.InfoPath.Client.Internal.Host.dll". It works if i use infopath only but if i make it browser compatible and try to publish it gives error"an administrator must approve this form template before it can be filled out by using a browser".I tried resolving it by the method

1. Open the Microsoft Office InfoPath 2007 form template by using Visual Studio 2005.
2. On the Tools menu, click Form Options.
3. In the Form Options dialog box, click Programming.
4. Click Remove Code, and then click Yes in the following message:
   This will delete all script files and Visual Basic and C# assemblies associated with this form template.
   
   Do you want to continue?
5. Click OK, and then publish the form template to the Microsoft Office Forms Server 2007 Web site. 

after following the above steps also it is showing me the same error,but if i clear the Full control option  and do the above steps it works but my form doesn action in that case.

Can anyone give me a soln for this,it would be a great help to me

Thankyou in advanc

In order to use managed code in a browser form in InfoPath the form has to be "admin deployed" and approved by an Admin in SharePoint.  Basically you sign the form and then admin deploy and the admin will then activate the template on the site.  If you remove the code though then your form won't work, so you have to admin deploy the form and leave the code in!

Hope that helps!

(and if you still have trouble with your form submitting to SharePoint lists after you get the form admin deployed then you might want to check out our qRules tool - http://www.qdabra.com/en/products/qRules.aspx qRules has a command to submit to a sharepoint list which many people find easier to use than writing their own code!)

Ted

Hi,

 Can you please elaborate in steps how to admin deploy and admin approve an infopath with code behind.

Thanks

Mubashshira