Solved

Infopath Form - Sharepoint - Warning

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

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)…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

691 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