I am new to infopath
I have built a basic form to be filled out by multiple users and submit data fields to a access database. I do not user in the access data so I have built an excel refreshable spreadsheet to pull from access to view submitted data.
Problem-When I have the excel refreshable open and try to query submitted data in my infopath form I get an error: InfoPath cannot connect to datasource..."try to connect" ..."work offline"
How can I query data in Infopath when the excel file is open?