Access Releases 7 Issue Fixes in Version 2310 (Released October 25th, 2023)
Our newest round of Access bug fixes was released on October 25th, 2023. In this blog post, we highlight some of the fixed issues that our Access engineers released in the current monthly channel. If you see a bug that impacts you, and if you are on the current monthly channel Version 2310, you should have these fixes. Make sure you are on Access Build # 16.0.16924.20106 or greater.Access fixes released in Versions 2501 and 2502
Version 2501 (Build 18429.20132) Bug Name Issue Fixed Ctrl+W doesn’t close the query window when using Monaco SQL Editor Several keyboard shortcuts that were not working properly when editing with Monaco will now function correctly SQL not saved correctly when using Monaco to edit control properties When using the property builder for the Row Source property to open the query editor, and editing with Monaco, spaces might be removed from the SQL, making it invalid Access terminates unexpectedly when setting “Option to enable Monaco SQL Editor” using Application.SetOption Application.SetOption now works correctly to set this option When saving a query with a syntax error using the Monaco editor, the error message might be incorrect In some cases, the editor would report that comments were only allowed at the beginning of a query, even when this was not the issue. File Open dialog doesn’t remember database location when saving backup When saving a backup database, the File Open dialog should default to the location of the open database, rather than the default save location Series sorting does not work in Modern Chart if series display name has been changed The new ability to sort a series in a Modern Chart will now work even if the Display Name of the series has been changed from the default name Version 2502 (Build 18526.20144) Bug Name Issue Fixed Error when saving query after applying a filter in datasheet view When the Monaco editor is enabled applying a filter in datasheet view and saving could generate an error Copying a query from one database does not transfer comments Comments at the beginning of a query should be preserved when copying a query from one database to another Form_MouseWheel event not reporting correct count The Page and Count arguments to this event were always False and 0, but will now report the correct values Some number filter menus not correctly named The Number Filters sub-menu had items for “Less Than...” and “Greater Than...”, but these options should read “Less Than or Equal To...” and “Greater Than or Equal To...” respectively Cannot use VBA code to set some new Modern Chart properties We added some new properties to ChartSeries, for example “Gridlines” and “Word Cloud Shape”, that could be set with the Chart Settings pane. These can now also be set using VBA code. Please continue to let us know if this is helpful and share any feedback you have.Access fixes released in Version 2410
Initial release Version 2410 (Build 18129.20116). Bug Name Issue Fixed Memory leak when using the Properties collection in VBA code Every time there was a reference to the Properties collection (e.g. obj.Properties("Text")) in VBA code, Access would leak memory. If this was done a large number of times, the memory usage of Access could increase significantly. Please continue to let us know if this is helpful and share any feedback you have.
