0

I have a table in Microsoft Access that contains much more then 5000 items. In addition, I created a MS access form which I published in SharePoint. In this form, the users have to select some options and at the end a filtered table will be returned.

On the server it works with no issues. But when I try to generate the filtered table on SharePoint, the message "Failed to retrieve list data" appears. It's because the table contains more then 5000 items. When I reduce the amount of items, it works.

Ironically with the use of my filters, the user should never get a result with more then 1500 items. But because the database has in total more than 5000, it doesn't allow to filter the table to begin with.

Is there a way to solve this problem?

sh olli
  • 11
  • 2

1 Answers1

0

If your user group is employing terminal services / remote desktop servers - one could deploy a split Access database without relying on SharePoint. This is possibly of no help whatsoever...…

SharePoint for sharing files, docs, etc - I understand. But a multi user database application is kind of a different animal....

Cahaba Data
  • 624
  • 1
  • 4
  • 4