Totally infuriating lack of detail on errors

[Wabiloo]

Developping Infopath forms is driving me nuts.
The latest one: I have a form linked to an Access database that was
working fine.
Suddenly, I get an error

"Infopath cannot run the specified query
[0x80040E10][Microsoft JET Database Engine] No value given for one or
more required parameters.
[0x80040E10][MSDataShape] Data provider failed while executing a
provider command."

With no way to know what parameters are missing (and h***, this form
has only two query fields, so really not much that can be required and
missing...)
I've removed all but one of the data fields on the dataFields side of
the form, and only left the two queryFields but I still get the error
:-X

Is there any way of debugging InfoPath forms or at least get slightly
more comprehensible error messages?

 

[SBFF]

The message "No value given for one or more parameters" usually means that
you typo'd one of the field names in your query. If you can, copy the query
and paste it into MSAccess as a new query (named test or something). When
you run it, it will prompt you with the name of the misspelled column.
If you can't copy/paste the query, just look at the column names & table
names very closely.
Good luck
SBFF

 

[Wabiloo]

I'd love to be able to do that.
However, where should I copy the query from?

From the data connection / edit sql statement?

This doesn't look like a standard sql statement (shape? append?
relate?)
Moreover, this pseudo-sql statement doesn't have a single "where" in
it, which seems to be where the problem is when running a query with
queryFields values in them...

 

[cooperaa]

*I'd love to be able to do that.
However, where should I copy the query from?
This doesn't look like a standard sql statement (shape? append?
relate?)
Moreover, this pseudo-sql statement doesn't have a single "where" in
it, which seems to be where the problem is when running a query with
queryFields values in them... *

I received this awful message several times today, when I finally
realized what was causing it. In my Access database I had renamed
several columns after creating the InfoPath form.

Check that your column names are the same in both files, and once they
are don't change them