InfoPath Dev

Hi Thomas, Great scenario. Should be totally doable with InfoPath and SQL. SharePoint has some perf limits with several thousand forms but if you use SharePoint Data View Web Part on SQL you can filter to only show the data you need and get around the limitations. We have several solutions in the 100k+ range of forms and visibility is fine with ...

Another alternative is to write code. It won't be as secure as using a Web Service (SharePoint's or Qdabra's) but you can do it. Search the forum for LDAP. There are many examples:  http://www.google.com/cse?cx=003654972516704994317%3A4j0mji2l1rq&ie=UTF-8&q=LDAP

Trusted Sites run at lower permission than is necessary for .NET code. QRules is a set of .NET assembly that provide common functionality. As such, it needs to run as local intranet or just default (nothing) but not Trusted Sites. Trusted Sites actually lowers the permissions and prevents .NET code from running in an InfoPath form with Domain ...

Hi Clayton, Thank you for trying qRules. Are you trying to Preview the form or publish and run? Is the site you are publishing to in Trusted Sites? If so, remove and add to Local Intranet. If that doesn't fix it, it's possible that the URL is wrong or that you are trying to use it with browser forms (not supported). Once again, THANK ...

Well, this is a common predicament. How about a little server side filtering of the data? Qdabra's DBXL Web Service provides server-side SQL filtering so that you can just download the data your form needs (filtering based on field values in your form). That means you reduce the amount of data you download to your client and realize ...

Qdabra provides an easier to use Active Directory Web Service with documentation and online support. It's free as part of the trial download of DBXL, so you can take it for a test drive for a couple months before you even have to pay for it. Check it out: http://www.qdabra.com/en/products/ADWebService.aspx. We have hundreds of happy users...

Hi Blackhawk, If the user's machine is joined to the domain and IIS is configured correctly on the server where the Web Service is running, and that server is part of the domain, you should not have any problems. You should make sure that the user's machine is joined to the domain. If not, the user can still connect to the Web Service, ...

Hi Ian, I don't know enough about your specific requirements to say this definitively, but I do suspect you are creating more work for yourself by using Access controls. I have developed hundreds of solutions over the last 10 years using Microsoft Office and specifically InfoPath, SharePoint, etc. And, I've only seen Access in use to ...

As usual, Clayton has excellent architectural advice. You don't need a Web Service to submit an InfoPath form via e-mail. You don't even need any code and using meta-data in your form to set the filename is also a good idea if you don't have access to SharePoint library IDs or SQL row IDs. Keep it simple!

Hi Ian, Sorry to hear you didn't get the InfoPath to Word thing working well. I don't understand why you would be using Access as a go-between for InfoPath and Word. That sounds strange to me. Here's a stupid question: are you sure InfoPath is the right tool for what you are trying to do? OK, back to reality. Now, just ...