Since last year Microsoft's Access team has published a monthly list of bug fixes for the latest versions of Access on its blog. To make this information more visible and searchable, we are collecting the full list for 2023 here and link to the Microsoft blog posts where you can find more description. For 2022 see here.
Reserved error -1001 when using a reserved word in a SQL query
Report in report view shows navigation controls
Can’t open a query directly into SQL view
Navigation Pane does not display text correctly when collapsed
When you navigate using the new Edge browser control using the Navigate method while the control is hidden, then set the Visible property to True, the control does not show the correct page
In some cases, using an append query with a linked Dataverse table could cause Access to terminate
Applying multiple filters to a linked Dataverse table could cause Access to terminate
Crash when opening a linked Dataverse table
Crash when creating a new form if the Normal form has a subform control
CopyFromRecordset command in Excel used to retrieve data from another Excel sheet using the Microsoft.Ace.Oledb provider could produce incorrect results
Memory leak when copying rows with attachments
Filter menus incorrection showing an underscore (_) rather than an ampersand (&)
Application.SetOption command does not work for “Continuous Form Record Navigation Keys” option
Crash when inserting records in form bound to ADO recordset
When saving a table, we may duplicate the table in the relationship window
Hang when hitting Tab key in design view
Listbox flickers when getting/losing focus
When a failure to connect to Dataverse occurs because of a broken network connection, Access displays Reserved Error -20345
Assigning Date/Time value to Date/Time Extended field through VBA generates error
When exporting a Date/Time field to SQL Server we create a datetime2(7) column
Dataverse connections assume accounts are in the commercial cloud.
Wrong error message when using TransferText
Opening a linked table in design view displayed a warning that the linked table definition couldn’t be edited
Error message can’t be dismissed in query designer
When exporting to SharePoint, invalid data may cause operation to fail with unhelpful error message
The AcSysCmdAction didn’t have an enumeration value defined that supported creating an ACCDE file
When an Edge Browser Control has Visible=No, the control would still render in form view
Narrator doesn’t narrate properly in subform controls
F1 does not link to the correct documentation for several properties of the Edge Browser Control.
When specifying a local file for a new Edge Browser Control, the file does not render
Error "Not enough free memory to update the display." when switching Office themes
Access would terminate unexpectedly if the Build Event command was selected for an Edge Browser Control.
The Edge Browser Control does not load local files specified with a UNC path
Opening a Query in some environments opens https://vscode.dev in the browser
The Edge Browser Control does not render content when an existing file is chosen in the Insert Hyperlink dialog on creation
Exporting report to XLSX format creates an empty workbook if the report has a Sum expression
Crash when trying to view related tables when exporting to Dataverse
Crash when setting control source to empty on Edge Browser Control
Data in linked Dataverse table isn’t updated while table is open
Export to Dataverse silently fails if attempting to export a table with unsupported characters
In Dark Gray theme, text in table designer is light gray on white background
Navigation keys do not work in Edge Browser Control
Clipboard shortcut keys (Ctrl+C/Ctrl+V) do now work in Edge Browser Control
The TransferDatabase action reports error ‘2001’ when importing from an unsigned database
Narrator reads the CLSID of ActiveX controls as the selection changes in the Insert ActiveX Control dialog.
Opening a Query in some environments opens https://vscode.dev in the browser
Performance degradation when using ADODB to manipulate data from Excel VBA
DLookup doesn't work properly if a TempVar, or other object is specified as the Criteria argument
The Edge Browser Control does not display local files if they have non-Ansi characters in the name
During Dataverse Export, there is little feedback
Out of memory error when opening a report
Multiple accessibility issues with the Contacts template
Cannot use a link to a table in an Access database with 20-character password.
When a control in a report has Can Grow or Can Shrink set to Yes, and uses conditional formatting, it may not correctly size the control.
The Result Type dropdown for a calculated column in a table does not show "Large Number."
Reserved error (-7747) when trying to link to SQL Server table with a spatial index on a geography column.
"#Deleted" displayed in table when linked to a SQL table with a geography column.
When "Allow Special Keys" option is off, breakpoints in VBA code do not work.
Error 3048 "Cannot open anymore databases" when exporting many reports to PDF.
Closing a report in print preview may cause Access to terminate unexpectedly.
Tables disappearing in Relationship window when selected and a table is saved in design view.
DAO DataTypeEnum enumeration does not include a value for Date/Time Extended.
When using the Zoom builder for the first time on a system with metric settings, the font is too small to be legible.
Error calling Query/Table refresh multiple times from Excel workbook to Access database.
Document tabs don't meet accessibility contrast requirements.
DoCmd.OutputTo acFormatXLSX doesn't work.
Some date filters do not work when there are Null values in the date column
When linking to a SQL Server table with a bigint column, Access does not prompt to enable linking as a Large Number
When inserting records into a linked SQL Server table with an INSERT trigger, the insert fails
When using a query as the Source Object for a subform, query design elements appear in form view
Access runtime does not validate digital signature
Access terminates unexpectedly when trying to open a linked Dataverse table in the browser
Export to Dataverse fails in non-English versions if table contains Yes/No fields
If the query designer is open when changing the Office theme, the query designer would not use the correct font
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”
留言