Microsoft Access 365, scrolling issue on Split Form

Question

UPDATE: It appears that when setting filters or loading the datasheet, access is taking a strange and inconsistent amount of time to load the records.

I set a filter that should return:

• 30 Records - > Returns instantly
• 50 Records - > Returns instantly
• 100 records - > Returns within 5 seconds
• 120 records - > Returns within 5 seconds
• 139 records - > Returns after 15 seconds
• 146 Records - > Returns after 30 seconds.

Does anyone have insight into why Access is taking so long to query records from the server intermittently? I had a few trials where even the 130 records took a while to return

ORIGINAL: I have a Microsoft Access 365 database that links to SQL server tables on the backend. I use a split form as my main entry form. When any user attempts to scroll down the datasheet using the scroll wheel, the form will "jump" to the last record and will not respond to any more scrolling. It requires me to refresh the sheet to get the datasheet unlocked.

The way to get the system to scroll correctly is to first hit "last record", which will force access to query all records, and then you can scroll freely.

This issue did not happen previously, when the backend table was hosted in SharePoint. This only manifested after a migration to SQL server, not sure if these are related.

I can provide screenshots of the behavior if this would be helpful. Any ideas on why access will not query all the records on load, and fails to scroll properly.