J
John B
We have a database which consists of approx. 54 tables
with relationships between tables. It is split, with back
end on a W2K file server & the front end on W2K Pro
workstations (approx. 60 users). All forms except one open
in an acceptable time (1-2seconds). This particular form,
which has two sub-forms, takes approx. 14 seconds to load
if there is more than 2 users using the database. With
only two users on the form opens as quick as all the
others.
Any suggestions as to why this should be happening would
be gratefully received.
with relationships between tables. It is split, with back
end on a W2K file server & the front end on W2K Pro
workstations (approx. 60 users). All forms except one open
in an acceptable time (1-2seconds). This particular form,
which has two sub-forms, takes approx. 14 seconds to load
if there is more than 2 users using the database. With
only two users on the form opens as quick as all the
others.
Any suggestions as to why this should be happening would
be gratefully received.