Access fixes released in version 2602 (Build 19725.20126)
Here's a summary of bug fixes in the latest version of Access: Bug Name Issue Fixed Monaco query editor applied unwanted autoformatting to passthrough queries The Monaco SQL editor was applying automatic formatting (such as adding whitespace or changing capitalization) to passthrough queries. Since passthrough queries are sent directly to the server's SQL engine without Access interpreting them, autoformatting could alter the SQL in ways that break server-specific syntax. Autoformatting is now disabled for passthrough queries, preserving the exact SQL as written. Monaco query editor font size did not match Access settings When using the Monaco SQL editor, the font size in the query editor didn't match the font size configured in Access's client settings. An incorrect unit conversion resulted in text appearing slightly larger than expected. The conversion has been corrected so the editor font size now matches the configured setting. Datasheet selection could extend past the last column When selecting cells in a datasheet by clicking and dragging, it was possible to extend the selection rectangle past the rightmost column into an empty area. Releasing the mouse and then clicking elsewhere would leave the selection highlight drawn in that empty area, since Access did not erase the over-extended selection. The selection is now properly limited to the actual columns of the datasheet. Please continue to let us know if this is helpful and share any feedback you have.
Datasheet view is slow to update when copy/pasting many rows
I have a customer who really wants to use the datasheet view/Quick edit for updating multiple rows at a time. They keep Excel sheets from where they copy/paste changes into the custom list, using datasheet view. I have recommended them to reduce the number of rows in views and keeping the number of updates in each copy/paste low, but of course they would like to do as many as possible in one go. The list now containg upwards of 500 rows. Anyone have any great tips on how to make this as smooth as possible? Also tell if there are any specific configurations that impact speed specifically - like row count, columns in view, type of columns, etc. We see that Chrome works faster than IE when loading the datasheet view, but we also see that copying/pasting multiple rows from Excel does not work. I know datasheet view in Chrome was not supported earlier, but should it not be supported for SharePoint online? Thanks for any tips.
