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