I am a non-programmer, but have successfully created an Infopath form in
which the user enters a client ID number and the form retrieves basic name
address information (read only). Other fields in form can be updated and
submitted back to the SQL database. All very successful, works like a charm.
The only trouble is that the first retrieval of the ID information is very
slow. Only 40 seconds in the main building, but ten minutes from outside
using the VPN - too slow to be useful. Have I done something wrong? Or is
there a way to optimize data retrieval speeds? The form is linked to 6 tables
and I notice speed decreases with each additional table. Tried publishing to
Sharepoint, but no difference in speed. Would the web work better?

Alex.