Form on front end loading slowly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am just looking for some ideas on this. Here is the setup that I have. I
have a database backend with a table that lists employees, and uses their SSN
as a key field. I have another table that has many field, but one that lists
their status as Active or Inactive, this table is also by SSN as the Key
field.

I have a form that will be used for leave requests. It has a combo box that
uses a query based on the above mentioned tables to generate a list of
employee names who are active. There is other information that is put in and
then the request is submitted.

What my situation is, with our network, it takes longer than I would like
for the form to open with the combo box on it. My quess is that the issue is
populating the list of names for the combo box. I am not really sure, we
only have about 350 employees. This front end is being used at an off-site
location but has DSL connection, so that may have something to do with the
speed issues.

Basically any ideas on how to improve speed in general for a database, and
specifically in the sitation I have would be of great help.

Thanks,
Jamse Stephens
 
I gather the user has a frontend that uses a backend database on a server
accessed via DSL/VPN or similar.

I believe that you will find this arrangement to be very slow even if the
application is perfectly optimized for speed. The DSL/VPN connection is just
too slow, especially in terms of latency, to handle the amount of
back-and-forth communication that goes on between a frontend and a Jet
backend.

You can look into using Remote Terminal Services where the frontend executes
on a server and only the screen results are communicated to the remote user.

TomU
 
Back
Top