Solved

Infopath Form - Sharepoint - Warning

Posted on 2014-04-17
4
1,732 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 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I made this because I wanted to get e-mail with a attached csv file so I'd would be able to import user input into a MS Excel template, but I also wanted to register/save all inputs from each day in a file on the server. 1st - It creates a temp C…
Before we dive into the marketing strategies involved with creating an effective homepage, it’s crucial that EE members know what a homepage is. In essence, a homepage is the introductory, or default page, of a website that typically highlights the …
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 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…

708 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now