We have a number of forms designed in 2007 and working well. We have upgraded to 2010 the published forms are working well. BUT when we edit the form in 2010 we get InfoPath cannot run the specified query, InfoPath cannot connect to the data source, Access is denied.
We have tried modifying the data connection and this works ok - but when previewing after modification we get the same error.
We have tried creating a new dataconnection in the same form - and this works ok - but previewing does not work.
If we start a new form in 2010 it works ok.
The data connection is to a SQL 2005 database, and there is a password set on the connection.
Please can someone point us in the right direction. We don't want to have to recreate the form from scratch.
Thank you
Catharine