Bug Fix for Access 2016 64 bit VBA DAO Update Query Bug in Long Text Parameter
Reposted here from MS Community Forums based on replies there:
Where I work I seem to have found some bugs in MS Access 64 bit (not in 32 bit) relating to using VBA to call update queries.
When calling an Update query from the current database via a 'qdf' object that has one or more long text fields to be updated, and supplying the values for those updates via Long Text parameters, it seems that supplying either a 1 or 2 character value can cause Access to crash when the qdf is executed, depending on the position of the parameter in the list of parameters in the query definition. If the parameter is later in the list, an invalid argument error is thrown instead.
There is also an additional bug where a leading or trailing backslash causes an invalid argument error. This also seems to affect short text fields.
I don't know how to report these bugs to MS directly which is why I've posted here.
Office 64 bit = Version 1808 (Build 10730.20264 Click-to-Run)
I don't have the code available to me at the moment, but I will see if I can reply with an example soon.