?
Solved

Infopath Form - Sharepoint - Warning

Posted on 2014-04-17
4
Medium Priority
?
2,013 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 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

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Viewers will learn the different options available in the Backstage view in Excel 2013.
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 …

800 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