RE: Form on front end loading slowly

From: TomU (TomU_at_discussions.microsoft.com)
Date: 02/12/05 

Date: Sat, 12 Feb 2005 05:01:03 -0800

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

"James Stephens" wrote:

> 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
>

Relevant Pages

  • Re: Split Database Security Problem
    ... Both frontend and backend ... > permissions, but as in all good stories there is a catch. ... The newAdmin for the 'object database' has the ...
    (comp.databases.ms-access)
  • Re: Split Database Security Problem
    ... Both frontend and backend ... > permissions, but as in all good stories there is a catch. ... The newAdmin for the 'object database' has the ...
    (comp.databases.ms-access)
  • Re: Multi users Logon Security questions
    ... > The next thing I need to do is split the database so others can work ... and navigate to the mdb - copy the mdb. ... You can use your desktop shortcut (which will open your frontend). ... Ctrl-O and open the backend mdb. ...
    (microsoft.public.access.security)
  • Split Database Security Problem
    ... I have managed to secure a split database. ... Both frontend and backend ... permissions, but as in all good stories there is a catch. ...
    (comp.databases.ms-access)
  • Re: Design problem : security layers
    ... I'd like to reuse the Objects i write for the frontend in the backend, ... So for the moment what i do is having two packages, ... the credit sub-package will contain all that behaviour that ...
    (comp.lang.java.programmer)
Loading