Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access97 database - Status reporting app - slow response time

Discussion in 'Information Technology' started by LenJr, Jul 28, 2006.

  1. LenJr

    LenJr
    Expand Collapse
    Guest

    I have an Access97 application that is being used by about 70 people. I have
    the front end on their workstations and the back end on the network. The
    response time when onsite if fine...but when offsite and logging into the
    system through VPN the response time is very slow. This is using DSL or
    Cable. People are waiting up to a minute or 2 for a form to display. Any
    ideas to improve the response time?
     
  2. Loading...

    Similar Threads Forum Date
    USA NSA has massive database of Americans' phone calls (USA Today 5.11.2006) Breaking News Jun 11, 2013
    Some database errors while navigating SPN forums Announcements Dec 29, 2004

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    LenJr wrote:
    > I have an Access97 application that is being used by about 70 people.
    > I have the front end on their workstations and the back end on the
    > network. The response time when onsite if fine...but when offsite
    > and logging into the system through VPN the response time is very
    > slow. This is using DSL or Cable. People are waiting up to a minute
    > or 2 for a form to display. Any ideas to improve the response time?


    70 users is a lot for Access, but it appears your problem is the
    connection. Access is very LAN demanding, less so when split as you have
    done, but still demanding. I doubt if you can do better with a VPN and you
    may experience corruptions, so be sure to back up often.

    Would it be possible to use replication?

    --
    Joseph Meehan

    Dia duit
     
  4. david epsom dot com dot au

    david epsom dot com dot au
    Expand Collapse
    Guest

    You could get that down to less than a second by using
    Microsoft Terminal Services or equivalent.

    Most businesses that support VPN also support Remote
    Desktop in one form or another. Ask your network
    people.

    (david)

    "LenJr" <LenJr@discussions.microsoft.com> wrote in message
    news:FFF49AEE-8C37-41E5-9ADF-CB1F14F85379@microsoft.com...
    >I have an Access97 application that is being used by about 70 people. I
    >have
    > the front end on their workstations and the back end on the network. The
    > response time when onsite if fine...but when offsite and logging into the
    > system through VPN the response time is very slow. This is using DSL or
    > Cable. People are waiting up to a minute or 2 for a form to display. Any
    > ideas to improve the response time?
     

Share This Page