List of fixes in 2023
Updated: Mar 20
Since last year Microsoft's Access team has published an (almost) monthly list of bug fixes for the latest versions of Access on its blog. To make this information more visible and searchable, we will collect the full list for 2023 here and link to the Microsoft blog posts where you can find more description. For 2022 see here.
Error ‘Duplicate out alias __Agg255’ when running a complex report.
Access shuts down unexpectedly when clicking on a subform control with no Source Object
Reserved Error -1038 reported when trying to run a query with a TOP clause when ordering by a Date/Time Extended field.
Some rows show # Deleted in a linked SQL table with DateTime2 columns
Error message “One of your parameters is invalid,” when expanding a sub-datasheet linked by a Large Number column.
Error message “Data type mismatch in criteria expression” when trying to filter on a Date/Time Extended column if the column is indexed.
Labels in the second column of form are not associated with the corresponding textbox
For a VBA project with a digital signature, saving the project would remove the signature, even if the signing certificate is available.
When running code requires notification, the DoCmd.TransferDatabase method will be blocked, even when a database is in a Trusted Location
When a query references a field, half-width and full-width characters are not considered equal, which can cause references to fail to resolve
When exporting to Dataverse, and filtering the list of available sites, Access may export to the wrong site
Setting the Horizontal Anchor property to Right may change the property value for controls to the left in a layout
Query design does not allow specifying Is Null as the criteria for a Date/Time Extended field
When specifying a Date/Time literal as the criteria for a Date/Time Extended field, an error occurs “Data type mismatch in criteria expression”