Results 1 to 5 of 5
  1. #1
    RasterImage is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Jun 2011
    Location
    UK
    Posts
    34

    Limit the SharePoint list records I link to

    Hello,

    I have an Access front end that I distribute to users, linked to SharePoint lists. As the lists are growing longer the database is slowing down. Can you think of any way of limiting the number of records that the front end links to?

    Here's a much simplified version of my situation:
    Say I have related SharePoint lists Users and Sessions, where each Session has a unique User with a Lookup field linked to the Users list.
    I have about 60 users and 5000 sessions so far. The Sessions table has about 20 fields.
    Each user has a copy of the front end, they are mostly working at home, not all have good computers or internet connections. Many keep their client files on Windows Virtual Desktop, which is being really slow at the moment.


    Their clients have tables which are linked to the SharePoint lists. Every time the links are refreshed they get ALL the sessions on their linked table. But they don't need that—each client is restricted to that user only, so each user only ever sees their own sessions.

    Is there some way of only linking the tables in the front end to just the relevant SharePoint records? I'll be very very grateful for any ideas or tips.

    (As I said, this is a simplified version, in fact there are many lists/tables, queries, forms, etc., but only a few of the lists have records numbering in the thousands).

  2. #2
    RasterImage is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Jun 2011
    Location
    UK
    Posts
    34
    I'm still desperate for an answer to this.

    I can create SharePoint views that meet my needs perfectly, e.g. I can filter a list by current user and records modified in the last 6 months. Could I create an Access table linked to that view?

  3. #3
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Have a look at this link, it shows how to link a SharePoint view using VBA:
    https://accessexperts.com/blog/2011/...crosoftaccess/

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  4. #4
    RasterImage is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Jun 2011
    Location
    UK
    Posts
    34
    Thank you Gicu, your link worked and I'm grateful.
    I thought I'd replied to thank you ages ago actually, sorry it took so long. I've been happily linking to views for a while now.

  5. #5
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Hey, glad to hear you got it going and don't worry, we all get busy !

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Limit Sharepoint List Entries By Column
    By Steven.Allman in forum SharePoint
    Replies: 1
    Last Post: 03-15-2021, 09:48 AM
  2. Access sharepoint list link issues
    By shakya69 in forum Access
    Replies: 1
    Last Post: 03-15-2016, 03:40 PM
  3. Replies: 1
    Last Post: 02-24-2015, 04:45 PM
  4. Replies: 9
    Last Post: 05-07-2013, 08:37 PM
  5. Link Access Query to Sharepoint List
    By mlm in forum SharePoint
    Replies: 0
    Last Post: 04-24-2012, 03:06 PM

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