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

    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
    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