InfoPath "The query returned large amounts of data..."

[mtarabochia]

I am using an infopath form connected to an access database. I sometimes get
an error message when running a query saying.
"The query returned large amounts of data and rendering your form may take
some time."
Is there a way to fix this?

 

[Shiraz Cupala]

Hello,
What is happening here is that the size of the return results have crossed a
threshold internal to InfoPath that causes this dialog to display. I don't
recall offhand what the threshold is.

Some techniques to avoid this dialog are to restructure your query to return
smaller sets of data and then page thru it, or to set query parameters to
filter the data you query for.

For example you could have some dropdown boxes that allow the user to select
values in certain data fields and then use those values as query parameters
to only return records with those values.

 

[mtarabochia]

The query field is connected to the ID of the record. I am using this
function to refresh the form. We don't have the service pack installed for
users so I cannot use the refresh feature available with the service pack.
The query field on the form that causes the problem is read only and
automatically fills in when the form is submited and the new ID number is
generated from the access database. Sometimes it works fine and sometimes it
gives the message listed above.