Results 1 to 2 of 2
  1. #1
    barbashop is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2017
    Posts
    1

    not all records loading in from linked sharepoint table


    Hi all...I have an access front end application where the back end is various sharepoint lists (sharepoint is via MS365). One of the larger sharepoint lists contains about 70,000 records. When I open the linked table in Access, not all the records load. Sometimes I get 300, sometimes 2000, sometimes 4000, sometimes 20,000, and once and a while the full 70,000 records. But even when I run queries off that table, they don't always show all of the records they are supposed to.

    I wanted to see if anyone has experienced this and has a solution?

    Thanks!

    Jeff

  2. #2
    NauticalGent65 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2016
    Location
    Prince George, Virginia
    Posts
    16
    I have the same setup as you, but my lists reside on an actual server. I do not have the same issues as you do, but I have experimented with linking actual list views instead of the complete list. It really improves performance because I am using server-side filtering.

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

Similar Threads

  1. Replies: 1
    Last Post: 08-31-2017, 05:17 AM
  2. Replies: 0
    Last Post: 08-27-2016, 03:45 AM
  3. Replies: 0
    Last Post: 06-11-2016, 03:44 AM
  4. Replies: 0
    Last Post: 04-04-2012, 12:42 PM
  5. Refresh Linked Sharepoint List to Show New Records
    By gopherking in forum Programming
    Replies: 1
    Last Post: 03-21-2012, 07:59 AM

Tags for this Thread

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