InfoPath Dev

It looks like the f(clean); shows up when the post is added to the InfoPathDev site as it's not in my connection XML on SharePoint and it doesn't show up when I paste the XML into my message, but when I submit my message to the site, the f(clean); is added for some reason - possibly some encoding the site does to keep users from embedding ...

I'm not exactly sure where the f(clean); is coming from.  When I look at the XML for my data connections within SharePoint, I don't see it.  I'm pasting the connection XML below again to see if it is added somehow when the post is added to this site.    <?xml version="1.0" ...

You should be able to do this without code. The issue is that publishing an Access DB to SharePoint sounds really cool and can be acceptable, in pretty basic scenarios, but I have not seen it really work, at least not with InfoPath integration. In reality your database is not really available there or hosted, they have just built a list view of ...

not totally sure... access publishes the database as a 'list' on the sharepoint sight. There are many things built in or 'out of the box' then probably an INFinite amount of things you can do with custom code. in order to do what i want...somebody pointed me to this ...

Are you using code to submit? Have you tried setting up the web service in data connections?

Using data connections to SharePoitn and webservices does not require full-trust. Only certain code in your form, if it is accessing something outside of InfoPath, would require full-trust and the form to be installed.  

Can you use SQL instead of Access on the hosting site? If you want, send me an email and I can maybe take a look at your requirments and come up with an ideas of how it can be accomplished.

If this is a static query you can edit the SQL select statement in the Data Connection. A web service can give you the ability to dynamically query. Within a form you can use the contains to get like functionality. What is your situation? What are you trying to do?

I mentioned this in a different post, but never heard back whether it did anything...  f(clean); seems to be out of place here. I don't have it in my data connection. I'm not sure where it come from or what it does. Try removing it and reuploading your udcx file to see if that makes a difference. Let us know the results.

I am working on infopath form that supposed to submit to SharePoint and WebService. Should this form be Full Trust or not necessary? I have created Web Service and added code in submit to submit to this web service but I am getting SecurityException if i am not setting form as full trust. thanks