Failed connections to large DB tables

[KLaw]

I am developing a form which has a main connection a several secondary
connections to an Access DB. One of the secondary connections is to a very
large (3000+ records) table. It opens fine (very slowly but acceptable) when
I am using it at the location where I created it. However, when a remote
site user tries to open it (from the shared network drive) it fails. I
believe that it "times out" while the query is trying to make the connection
to that large table (the error tells me so!)
I figured out that I can uncheck the "automatically connect each time the
form opens" box, but now how do I make the connection to that table on demand?
Any help is always appreciated!
Thanks,
Kammy

 

[S.Y.M. Wong-A-Ton]

Whenever you call Query() on a data connection, you make an on-demand call to
it. You can also use the "Query using a data connection" action in a rule to
do the same thing. These suggestions are for InfoPath 2003.