Opening form is very slow

[James T]

I have created a mulit-user database (must admit I am not a database guru but
one dabbles).

When testing on my local pc the data entry form opens quickly.

However once I moved it to the server last night (front end database sits on
each users pc, only backend database is on the server), the data entry forms
opens slower.

Then when I had two users try and access the data entry form it takes about
20 seconds to open the form.

I would expect some level of speed reduction b/c of the server connection
and multi-user access, but not 20 seconds.

The only things I can think of is that the data entry form has about 9-10
subforms in it which may be causing the slowness.

1) could the multiple subforms be the issue?
2) Any ideas on how to speed up the form opening in mulituser situation?

Any feedback would be appreciated.

Regards

James

 

[Sandra Daigle]

First take a look at this FAQ by Tony Toews. There are many issues which
could affect performance across a network and this addresses most of them.

9-10 subforms on a data entry form could also impact performance. Since it
is doubtful that all are in view at any one time you might want to consider
unbinding the subform controls from their Sourceobjects until the subform
comes into view. This is easily done using the Change event of a tab control
(which I'm guessing you have on this form).

 

[Jeff Conrad]

I think Sandra forgot to include this:

http://www.granite.ab.ca/access/performancefaq.htm

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[Sandra Daigle]

Yeah, maybe ;-)

Thanks Jeff!

 

[Jeff Conrad]

No problem.


--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message: