super slow GUI on split MS access database

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Pierre Damme
    New Member
    • Nov 2010
    • 1
    #1

    super slow GUI on split MS access database

    Hi,
    I have a split database (tables (1.3MB) on server and GUI (7MB) on both server and laptop).

    When opening the GUI using a vpn connection on the laptop the application loads very slowly and when i open a form (from a menu in the GUI) it takes forever to load.

    when it has loaded the form and i choose a record from a dropdown list in the form it takes forwever again to load.

    It seems like there is a lot of traffic between the server and the laptop using vpn.

    What can be wrong with this application ?
    Please help !

    Pierre
    Tags: gui, ms access, slow, vpn
    • munkee
      Contributor
      • Feb 2010
      • 374
      #2
      The issue is very likely to be that you are now working within a WAN and not a LAN. Wide area networks will always be snail pace slow if you are running a typical split database set up where your client has the front end and the back end is hosted as a mdb file on a server folder.

      The only way for you to increase the speed is to upsize your backend to a mysql or similar server.

      For full information regarding why WAN's are inheritently slower there is a great article here:

      Shaw Communications
      http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html

        Comment

        Previous template Next
        Working...