InfoPath Dev

I have an Infopath form that submits the data onto a SharePoint list. Everything works if the user has 'view, insert, edit, delete' access to the list. However, we dont want them to be able to delete and view the item so we gave this user group only 'insert' access. After doing so, they get the following error message:

The following DataObject either cannot be created or cannot be initialized:
The query cannot be run for the following DataObject: NameOfList
InfoPath cannot run the specified query.
The SOAP response indicates that the error occurred on the server:

Server was unable to process request. ==> The root element is missing. 

Anyone know if there's another way to solve this without granting the user group full access to the List?  

 

Thanks for the help

Hi, you can create a Service account that have full access just to this library, and use this account to send your xml, with a WebClient or Sharepoint Webservices

Hi Potemkine, Im a newbie ^^....can you please elaborate more? The users have full access to the form library...what is a service account? I'm only a web designer, I'm limited to what I can do on SharePoint side. Thank you

AzuDaioh:

Everything works if the user has 'view, insert, edit, delete' access to the list

Anyone know if there's another way to solve this without granting the user group full access to the List?  

You just say you don't have a full access and don't want it so if you always use an account  that have the right permission and use this account to send the xml to your sharepoint library, I don't have the exact code that you need but you can look at this as an example:

http://www.bizsupportonline.net/infopath2007/programmatically-retrieve-infopath-form-from-sharepoint.htm

you have to change  

lists_ws.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials;

by

lists_ws.Credentials = new System.Net.NetworkCredential(_userName, _password, _domainName);

when user, password and domain is the credential of your user account.