Results 1 to 2 of 2
  1. #1
    SteveApa is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015

    Access w/ Linked Lists run slow until 1st table opens

    I have a database that uses Sharepoint linked lists. Every time I open the Db and open the 1st linked lisat, it is very slow. It seems that once it makes that first connection, it then go fast. Any ideas?

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2012
    Knoxville, Tennessee
    There is a 'known issue' with SharePoint's initial load. SharePoint runs on the .Net framework on IIS, which goes to sleep by itself, or in your case an IISRESET restarts all the services.
    Though the IIS services are running, nothing is going on until that first request is made to the website. At that moment, the .Net Framework has to compile all of the DLLs that comprises SharePoint and its features. So the initial load will take a long time, and the more services/features you're using (User Profile, Metadata, etc), the longer it'll feel as it all wakes up.

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

Similar Threads

  1. Access is hanging when importing linked lists
    By cveld in forum SharePoint
    Replies: 0
    Last Post: 10-07-2015, 04:24 AM
  2. Slow INSERT on a Linked SQL Table
    By altemir in forum SQL Server
    Replies: 5
    Last Post: 07-22-2013, 04:57 PM
  3. Syncronizing Linked Lists from Sharepoint to Access
    By se7en9057 in forum Import/Export Data
    Replies: 0
    Last Post: 11-02-2011, 02:04 PM
  4. Slow linked table
    By Okidoo in forum Programming
    Replies: 0
    Last Post: 05-19-2011, 03:02 PM
  5. Replies: 1
    Last Post: 01-22-2011, 12:23 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