If you have created InfoPath forms for simple CRUD operations with SQL Server, have you ever wondered how to refresh the secondary data source which refresh on Submit? InfoPath form provides an action called “Refresh”, but for that you need to use an extra button in the form. The user has to click the Refresh button every time whenever they submit the form, which is not that intuitive, right?! So, what is the alternative? How do you refresh the secondary data source, which loads the latest values...

Problem: Recently, when I was trying to run an InfoPath form (.xsn file) as different user from a client vista machine, which doesn't have the SQL server database access which the InfoPath form needs. The problem is more specific to InfoPath (as it allows only two types of authentication to SQL Server through InfoPath (NT and SQL User).So when you design InfoPath form to use NT access which is not a SQL User, it must run InfoPath natively as the NT user who have access rights on SQL User. But if...