By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,777 Members | 1,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,777 IT Pros & Developers. It's quick & easy.

Front End Form Opens Slowly across Network

P: n/a
I have an app containing 9 forms which have approximately 2 to 3 combo
boxes and 7 to 8 text boxes + a few labels (in each form).

On the same PC the forms open very fast. However when I load the front
end of the app on another PC across the network (100mbps), each form
takes about 30 to 40 seconds to open the first time & subsequently
approx 5 to 6 secs to open.

The rowsource of the combo boxes are SQL statements as follows:
combo1 pulls approx 1200 rows of data
combo2 pulls approx 15000 rows of data
combo3 runs a SQL distinct across a table containing approx 15000
rows.

Waiting for the forms to open is unacceptable to me & subjecting my
clients to this would be really mean on my part. So far none of them
have complained (and I don't plan to wait for them to do so either :-)

I'm certain the delay is caused by all these rows of data being pulled
across the wire. Access not being a true client-server app must be
pulling all these rows to process on the client pc & my guess is this
is what's causing the delay.

Would some of you gurus please post some pointers as to how I should
go about speeding up this process. I'd really like for the forms to
open "BANG" as when run on a "local" pc.

Thx & Best Rgds,
Prakash.
Nov 5 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Wed, 5 Nov 2008 14:46:00 -0800 (PST), pr*************@gmail.com
wrote:

You could check the Performance FAQ on Tony Toews' website.

Also realize that a dropdown list with 15,000 items is about 100 times
too many. Be creative, and come up with a better interface.

-Tom.
Microsoft Access MVP

>I have an app containing 9 forms which have approximately 2 to 3 combo
boxes and 7 to 8 text boxes + a few labels (in each form).

On the same PC the forms open very fast. However when I load the front
end of the app on another PC across the network (100mbps), each form
takes about 30 to 40 seconds to open the first time & subsequently
approx 5 to 6 secs to open.

The rowsource of the combo boxes are SQL statements as follows:
combo1 pulls approx 1200 rows of data
combo2 pulls approx 15000 rows of data
combo3 runs a SQL distinct across a table containing approx 15000
rows.

Waiting for the forms to open is unacceptable to me & subjecting my
clients to this would be really mean on my part. So far none of them
have complained (and I don't plan to wait for them to do so either :-)

I'm certain the delay is caused by all these rows of data being pulled
across the wire. Access not being a true client-server app must be
pulling all these rows to process on the client pc & my guess is this
is what's causing the delay.

Would some of you gurus please post some pointers as to how I should
go about speeding up this process. I'd really like for the forms to
open "BANG" as when run on a "local" pc.

Thx & Best Rgds,
Prakash.
Nov 6 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.