One form slow to open with more than two users

[John Baldwin]

We have a Access 2000 database, the backend of which
contains approx. 54 tables with relationships between all
of them. This sits on a W2K file server, the front end is
a .MDE, which is installed on each workstation (W2K Pro).
One particular form is slow to open if more than two
people have the database open (14 seconds).With only two
people using the database, but with others on the network,
the form opens in 1 to 2 seconds the same as all other
forms. It doesn't seem to matter how many people above 2
are using the database, the time to open stays at 14
seconds.

Could anyone suggest reasons for this & possibly some way
of getting round the problem.

Thanks
John

 

[Allen Browne]

There are quite a number of factors that can affect this.

Go to:
http://www.granite.ab.ca/accsmstr.htm
and check the Performance FAQ.

 

[John Baldwin]

Thanks for the quick reply.

Have already looked at that site & have checked or changed
the appropriate settings for the three main reasons for
forms to be slow to open - no luck.

It is only this one form which is slow, there is no drop-
off in performance with any of the other forms no matter
how many people are using the system.

 

[Albert D. Kallal]

If the keeping a connection open to the back end did not help, I would try
deleting the links to the back end, and re-creating them. (that is not the
same as refreshing).

I would then re-try the test, and MAKE SURE you keep a connection open to
the back end in the application at start-up BEFORE you try and load that
form.