https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/63476.aspxMon, 24 Jan 2011 17:25:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:63476Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/63476.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=63476<p>Hi, Catharine:</p> <p>If you open the SharePoint site in Internet Explorer, what security zone is it in? That&#39;s what I&#39;d check first, see if the site is in your Local Intranet.</p>https://www.infopathdev.com:443/forums/thread/63424.aspxFri, 21 Jan 2011 17:11:00 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:63424Catharine0https://www.infopathdev.com:443/forums/thread/63424.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=63424<p>Hi All,</p> <p>I have a form (2007) which has been running for the last 6 weeks or so.&nbsp; In the last couple of days I have had a problem with many users getting an Access deinied error message.</p> <p>The form is a SharePoint Content type.&nbsp; The users are able to open the form.&nbsp; The first thing that the form does is generate a sequential number (I do this using the technique Hilary described in <a href="http://www.infopathdev.com/blogs/hilary/archive/2008/11/21/fun-with-sequential-form-ids-sql-and-sprocs.aspx">http://www.infopathdev.com/blogs/hilary/archive/2008/11/21/fun-with-sequential-form-ids-sql-and-sprocs.aspx</a>)&nbsp; This worked really well.</p> <p>When I open the form in preview (from my desktop)- everything works ok.&nbsp; When I publish the form to sharepoint and open the form (same pc, same username) get the following message.</p> <p>The query cannot be run for the following DataObject: GenerateGUID<br />InfoPath cannot run the specified query.<br />InfoPath cannot connect to the data source.<br />Access is denied.<br />Access is denied.<br />I have not changed the form.&nbsp; I have not changed the permissions on the SQL Database</p> <p>This is not the only form which is has developed an issue.&nbsp; I have discovered a second form.&nbsp; Different sharepoint site, different sql database.&nbsp; From my PC in preview mode it works fine.&nbsp; From published form, (same pc same user name) I get </p> <p>The query cannot be run for the following DataObject: CheckForExisting<br />InfoPath cannot run the specified query.<br />Access is denied.<br /></p> <p>I have republished both&nbsp;forms with Full trust and the errors go away.</p> <p>It feels like some change to our environment - but I really don&#39;t know what to start looking for.&nbsp; I could just leave the forms as full trust (I do have a certificate) but I would prefer to understand the issue.&nbsp; Could any one suggest places for me to look/ things to look for&nbsp;?</p> <p>Thank you .</p> <p>Catharine</p>