Clay, thanks. Must the folder where the form is published on the web be
writable by all who use the form? That is what this link seems to indicate:
http://office.microsoft.com/en-us/infopath/HA011417761033.aspx#2
With this stmt: Ensure that users have write permissions to the shared
folder If you publish a form to a shared folder, you must make sure that
your users have write permissions to the shared folder before publishing the
form. This enables your users to fill out the form and save it back to the
same folder.
Does that then mean that anyone using the form could make changes to the form?
Thanks.
> Hey Zeon.
>
[quoted text clipped - 24 lines]
> > why our system is prompting for the password? If that is the case, is there a
> > way to turn this off? Thanks!
The template, the .xsn file, is different then the completed forms which are
an XML file. Where are they submitting the completed forms to?
You can secure the XSN file differently then the rest of the folder if needed.
In theory someone could update the template if you do not set specific
permissions. Also you should turn off the design mode option and go through
your form options and make sure you have it configured for production.
There are some advantages you get publishing to SharePoint or SQL that you
do not get with a file share.

Signature
Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum
> Clay, thanks. Must the folder where the form is published on the web be
> writable by all who use the form? That is what this link seems to indicate:
[quoted text clipped - 36 lines]
> > > why our system is prompting for the password? If that is the case, is there a
> > > way to turn this off? Thanks!
zeon - 06 Feb 2008 17:36 GMT
Clay, excuse my ignorance, as I'm still learning InfoPath. I have my data
source pointing to an SQL database which is located on an SQL cluster that is
different from where the XSN is published on the web, so I guess they are not
sending the form XML anywhere (I guess that is why, everytime they exit the
form, it asks if they want to save it, to which I've told my users to reply
no). Thanks.
> The template, the .xsn file, is different then the completed forms which are
> an XML file. Where are they submitting the completed forms to?
[quoted text clipped - 47 lines]
> > > > why our system is prompting for the password? If that is the case, is there a
> > > > way to turn this off? Thanks!
Clay Fox - 06 Feb 2008 18:05 GMT
Oh so the form is just to view and update SQL records directly.
If that is the case then go into form options and uncheck the Save and Save
As. This will eliminate the prompt.
I have doen this but witht he form published to a web site. You may have to
give them write permissions on the folder since it is on a share.
If you are working with SQL you may want to check out switching to web
services at some point. I usually start to run into some of the limitations
of the defualt SQL connection eventually, such as not being able to
dynamically query or submit to tables other than in my main table structure.

Signature
Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum
> Clay, excuse my ignorance, as I'm still learning InfoPath. I have my data
> source pointing to an SQL database which is located on an SQL cluster that is
[quoted text clipped - 54 lines]
> > > > > why our system is prompting for the password? If that is the case, is there a
> > > > > way to turn this off? Thanks!
zeon - 07 Feb 2008 13:38 GMT
Clay thanks for the suggestion, but for some reason, this did not solve the
problem. I still get 2 web-pass prompts before the form opens. Also, with the
save and save as unchecked, it now gives this newprompt when closing the form
(even if no changes were made):
"Do you want to submit form1?"
Thanks for your patience!
> Oh so the form is just to view and update SQL records directly.
> If that is the case then go into form options and uncheck the Save and Save
[quoted text clipped - 66 lines]
> > > > > > why our system is prompting for the password? If that is the case, is there a
> > > > > > way to turn this off? Thanks!