Hi everyone! This is my first time to post a question here on the Power Apps community.
I've been developing a Microsoft Access solution that uses Dataverse for Teams as the backend, and I'm using linked tables to gain access to the backend data. Out of twenty (20) tables, I have three (3) transaction tables that contain a significant amount of data: 4K+, 4K+, and 13K+ respectively.
Microsoft Access does fine when I open the first two tables and jump from the beginning of the table to the end, using arrow keys. But when I do the same to the 3rd table, which by the way only contains ten (10) fields or columns, it freezes when I attempt to jump to the very end of the table. I thought I could get around this by scrolling down through each row one at a time, but even when my cursor has reached only the 200th row of the table or so, Access starts freezing, and it remains that way for more than 10 minutes, so I just close Access by force when that happens.
I thought this behavior would only happen when I was opening the linked tables directly, but unfortunately this same behavior happens when I query the linked table (the 3rd one) using SQL.
Thinking this was an issue about having too many records, I tried testing Dataverse for Teams and created a table with only two (2) fields (an ID, and a string value), with more than 40K+ records. Surprisingly, I can access this on Microsoft Access via linked tables and I can jump to the very end of the table after the linked table freezes for only less than 20 seconds.
Lastly, I tried linking to the Dataverse for Teams table with issues using a new Access database, but unfortunately it suffers from the same slowness.
I would love to hear your thoughts on this. Thank you!
