InfoPath Dev

Our installation uses Infopath 2003. We have 2 users that are unable to load Infopath forms that have connections to an access database.  I recently found out they have Infopath 2007. They receive the error "THE QUERY CANNOT BE RUN FOR THE FOLLOWING DATAOBJECT:  Then the name of the table (from the Access database) appears.  INFOPATH CANNOT RUN THE SPECIFIED QUERY.      INFOPATH CANNOT CONNECT TO THE DATA SOURCE.   INFOPATH HAS ENCOUNTERED AN ERROR....

Does anyone know what's going on here.

Hi Ed,

InfoPath 2007 should query data from an Access database. Can you post the rest of the error? This looks like an issue with the database and not with InfoPath.

Sorry to hijack the thread, but I am having a similar issue.  IP 2007 form built on a SQL DB as the main data source and published to a SP forms library.  There are several other secondary data sources connected to the form.  When I run the form from my local machine, no problems.  When I go to the SP forms library and 'fill out a new form', no problems.  When I go to another machine, log in as me (or anyone else for that matter) I get this error:

The query cannot be run for the following DataObject: Main connection

InfoPath cannot run the specified query.

InfoPath cannot connect to the data source.

InfoPath has encountered an error.

The operation failed.

I have tried a multitude of things to overcome this problem to no avail.  Any assistance would be greatly appreciated.  I have come a long way on this form and this is the last step (outside of a bit more QA) before production and I am dead in the water.  I am not sure that I understand why deploying a form is so unblievably difficult!

 I solved this by making the form full trust. I might add something that infopathdev does not recommend.  Use at your own risk. :)