Hello all.
We have FE application in MS Access ( Developed on Office 365 Pro Plus ) that is linked to a MS SQL Express DB as BE. After Access Runtime 2016 was updated to version 13231.20262 ( build 2009 ), the datetime2 fields in the tables started to be interpreted as text. This only happens when the field is connected to a declared variable in VBA and used in a form. If we make a new form in Access and link the field through the Access UI, the field is correctly interpreted as date. Before the update there was no problem with this data type and VBA. Everything was working as intended. I hope this is a bug from Microsoft's end, but if someone can elaborate on the issue and give us an advice, it would be great.
Additionally we saw that now the data type in Access is Date/Time Extended. Before the update it was Date/Time. Maybe this is the issue. VBA does not work correctly with this newly introduced data type still?
Thank you in advance.