Solved

Infopath Form - Sharepoint - Warning

Posted on 2014-04-17
4
1,881 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

726 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