About Dat Time (extended Version) Apr 2026

: If you are linking to an external SQL Server database, go to File > Options > Current Database and check the box for "Support Date Time Extended (DateTime2) Data Type for Linked/Imported Tables" . Using the Date/Time Extended data type - Microsoft Support

: Open your table in Design View and select "Date/Time Extended" from the Data Type drop-down menu. About Dat Time (Extended Version)

: Using this data type marks your database as a newer version, meaning it cannot be opened by older versions of Access (e.g., Access 2016 or 2019). : If you are linking to an external

: Currently, this data type is only available in Microsoft 365 and Access 2021 . Access 2016 or 2019). : Currently