Some records not showing in access table that is linked to sharepoint list (though they are there) RRS feed

  • Question

  • I'm getting some bizarre behavior which is causing problems through the Database with queries and forms, etc. One or two of my lists, when viewed as tables when first opening the database sometimes show few or no records though the list has around 2500. I have understood that there may be a problem when the list size gets closer to 5000 and it could very well be that the size is causing the problem. However, I'm noticing that as soon as the list is sorted, the full amount of records show and all database operations function normally involving those lists.

    I've seen a thread where someone had a similar problem and each time they refreshed or re-linked the list, all records showed. I think they built a code to automatically refresh the list when a button is clicked or the database is open. Refreshing or re-linking the list does not work for me, But sorting does.

    1) is this behavior the kind of thing I should expect because of the list size or is there another possible cause?

    2) if it is, is there a way of improving the quality of the list somehow through sharepoint?

    3) If the only thing that will work is re-sorting, does anyone have a suggestion for a code I can install somewhere to make that happen?

    4) Is it time to give up on sharepoint and if so, where do I go next? 

    Any answers you guys can give would be appreciated. Thanks
    Friday, October 26, 2018 7:22 PM

All replies

  • Hi Mike,

    I don't have an answer for your specific situation but just wanted to offer a quick comment. If your data needs are approaching SharePoint's limitations for handling large data, then I would also say it's probably time for you to start thinking about migrating your backend into SQL Server or Azure.

    Just my 2 cents...

    Friday, October 26, 2018 7:30 PM
  • Thanks DB. Hoping for a workaround until that I can make that happen and I know nothing about  either of those or how they would be implemented but I guess it's time to get on google and try and find out.

    Is Azure just a higher end version of sharepoint, as far as hosting a backend goes and do from what you may know, is a migration to Azure (while still using the Access frontend) a complicated process and will all the forms, queries, codes, etc  already built be able to be used with Azure?

    Friday, October 26, 2018 7:38 PM
  • Hi Mike,

    The way I would probably describe it is Azure SQL is a web or cloud version of SQL Server, which would be a desktop/server version of a database. So, if you migrate your SharePoint data to Azure SQL, then you should still be able to use your existing Access frontend to connect to the data in its new location. All your forms and code should still work the same way.

    Just my 2 cents...

    PS. Of course, it's the same comment if you decide to use SQL Server instead of Azure SQL.

    Hope it helps...

    • Edited by .theDBguy Friday, October 26, 2018 7:44 PM
    Friday, October 26, 2018 7:43 PM
  • Thanks for the additional input. Sounds viable
    Friday, October 26, 2018 9:04 PM