?
Solved

Infopath Form - Sharepoint - Warning

Posted on 2014-04-17
4
Medium Priority
?
2,144 Views
Last Modified: 2014-04-24
Hi

I have created a form which queries a second list for data.

The form opens and works fine when I work on it.  However when users try to open the form. They receive a warning message as below.  

By clicking OK they can access the form and edit it.  But I am at a loss as to how to supress this Warning message.

Any help would be greatly appreciated.

An error occurred querying a data source.
Click OK to resume filling out the form. You may want to check your form data for errors.


You do not have permissions to access a SharePoint list that contains data required for this form to function correctly.

SharePoint - InfoPath - warning
0
Comment
Question by:businessops
  • 2
  • 2
4 Comments
 
LVL 28

Expert Comment

by:clayfox
ID: 40007238
1st is to make sure the URL you used in setting up the data connection is viable for the users.  Have them load that url/ list from their browser.  I have seen where the developer can access data with a different UNC or URL then users of the published form.

The users need to be able to access the default view of the SharePoint list.  I believe they should only need read access but i seem to remember issue where they may need contribute access.  Should be able to play with a test users to verify.

Is the SP list on the same site?  You could run into the double hop issue if the form is hosted from one site and the list data you want is on another.
0
 

Author Comment

by:businessops
ID: 40019999
Hi Clayfox

thanks for the reply.  I can confirm that the list used by the query in the form is on the same site.  I can confirm that the user was able to access the list and has contribute permisisons. Still getting the warning, but as i say its not stopping test users from completing the form and submitting it.

Cheers
Paul
0
 
LVL 28

Accepted Solution

by:
clayfox earned 2000 total points
ID: 40020044
Are there any other data connections in the form?  You probably need to investigate all data connections since the error may be coming from another, "non essential", data connection.
0
 

Author Closing Comment

by:businessops
ID: 40020144
Thanks Clayfox that was the issue. I removed a legacy data-connection and it's  working fine now.

Cheers
Paul
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question