Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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?
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page