Dataconnection with 2 tables is very slow over WAN

E

EK

We use a form on our WAN. In one of our plants, our 2 table data connection
takes minutes to retrieve 1-4 rows of data.

PurchaseOrders

POItems

The field that links them together is an integer field called PRID

If I create a new form and search on just PurchaseORders by PRID - 5 second
retrieval GREAT

If I create a new form and search on just POItems by PRID - 5 second
retrieval GREAT

If I use the form where both tables are linked to the MainDataConnection
(retrieve and submit), - 3 minutes. BAD

WE ARE HOPING THERE IS A WAY TO FIX THIS WITHOUT RE-DESIGNING THE FORM.
 
K

kumar

EK said:
We use a form on our WAN. In one of our plants, our 2 table data connection
takes minutes to retrieve 1-4 rows of data.

PurchaseOrders

POItems

The field that links them together is an integer field called PRID

If I create a new form and search on just PurchaseORders by PRID - 5 second
retrieval GREAT

If I create a new form and search on just POItems by PRID - 5 second
retrieval GREAT

If I use the form where both tables are linked to the MainDataConnection
(retrieve and submit), - 3 minutes. BAD

WE ARE HOPING THERE IS A WAY TO FIX THIS WITHOUT RE-DESIGNING THE FORM.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Infopath form is really slow 2
Problems after linking to tables over WAN 23
Contact Selector within Repeating section (submitting to SharePoin 0
System account Issue in MOSS 2007 0
What is the purpose of Digital Signatures? 0
2 Different Database Submit Actions in 1 Form 3
Access 2003 runs slow after 2-3 searches 14

Top