Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    27

    Question Unanswered: Update back end table slow over network

    Iím using Access 2003 with Windows XP professional. I have a front end data base with tables that are linked to a back end . The back end table name is Source Records. The user uses a front end form bound to a table in the front end called Data Entry. They enter the data on this form and once the data in the Data Entry table has been verified with a bunch of VBA if then statements I have an update query that updates the linked table Source Records in the front end with the data that they have entered in the front end Data Entry table.

    When I use it in my department which I believe is closer to the server it runs fine, when someone 2 floors up runs it the update query is painfully slow.

    Iím sure our network isnít the greatest but are there any tips or a possible redesign I could do to improve the performance of the update query? I would go to our IT with this but they are swamped.

    I would like to have many users using this but if I canít speed it up thereís no use.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Make sure each user is running their own copy of the FE, don't have lots of users opening the exact same file.

    You might also like to look at unbound forms instead of having the local table data copied with an update query.

    If performance is a critical issue, you also may want to consider upsizing the BE to SQL Server or MySQL.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Mar 2007
    Posts
    277
    Tony Toews has a few suggestions worth looking at:
    http://www.granite.ab.ca/access/performancefaq.htm
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •