Results 1 to 2 of 2
  1. #1
    slevine is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Jan 2011
    Posts
    1

    Large SQL Server table linked to Access datasheet is slow to update on first update

    I have a Access 2003 app that allows the user to work with SQL Server data in a datasheet view. The SQL table is linked to the Access db. When the user tries to edit/update a cell in the datasheet it is very slow the first time the table is edited. After that the updates/edits are immediate.



    Any ideas??

    The SQL table contains > 2,000,000 recs.

  2. #2
    ajetrumpet is offline Banned
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    the size might be part of it, not sure.

    how are the links set up?? as in, when access starts, how is the link established and/or invoked?? with the odbc sql driver, or a file dsn, or another method?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 03-29-2012, 07:45 AM
  2. Replies: 0
    Last Post: 11-30-2010, 12:23 PM
  3. Update statement with linked table join
    By Guigui in forum Queries
    Replies: 6
    Last Post: 09-17-2010, 04:47 AM
  4. Automatically update datasheet
    By tammiep in forum Forms
    Replies: 1
    Last Post: 08-17-2010, 04:43 PM
  5. Replies: 3
    Last Post: 01-21-2010, 08:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums