For those of you working with Access / Office 365  with SQL Server back ends, and are on the current channel, be aware that it looks like a major bug exists with version 2009.

With this version, Microsoft has introduced a new data type called "Date/Time Extended" for better compatibility with SQL Server’s datetime2 data type (https://techcommunity.microsoft.com/t5/access-blog/introducing-our-new-data-type-date-amp-time-extended/ba-p/1746980) and it's getting activated automatically when it should not be.  

That means the next time you relink a table, the date/time field definition becomes the new data type.   The issue with that is there is no corresponding type in VBA and any code you have that works with the field will treat it as a string. This will break your application.

At the present time, the only thing you can do is roll back to 2008.  

0

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month