Multiple Database Results to a single page *strange bug?*

[DDL]

I have two database results wizards on one page. They both work fine...most
of the time, however I’d say about 10% of the time only the top one returns
records and the bottom one does not. (top and bottom meaning thats how they
are laid out on the page..) I've checked my query logic and that is fine.
Even when querying identical information most of the time both return records
and like I said before only 10% of the time only the top one returns records.
It seems to perform this way regardless of what browser/OS I’m using...and
regardless of what information I query. The bottom one does not return any
error just gives me the no records to display message (or something close to
that)

Is there some sort of bug associated with multiple DBRW on the same page?

 

[Stefan B Rusynko]

No
But it is possible that Access is "timing out" depending on the complexity of the query and # of open connections




|I have two database results wizards on one page. They both work fine...most
| of the time, however I'd say about 10% of the time only the top one returns
| records and the bottom one does not. (top and bottom meaning thats how they
| are laid out on the page..) I've checked my query logic and that is fine.
| Even when querying identical information most of the time both return records
| and like I said before only 10% of the time only the top one returns records.
| It seems to perform this way regardless of what browser/OS I'm using...and
| regardless of what information I query. The bottom one does not return any
| error just gives me the no records to display message (or something close to
| that)
|
| Is there some sort of bug associated with multiple DBRW on the same page?
|

 

[DDL]

It is a group by query. That may make it more complex....but in terms of
queries it really is not that complex of a query. I wonder if there is an
alternative to maybe if it is timing out to force the page to not display
until fully loaded.