About Dat Time (extended Version) -

: 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

: 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). About Dat Time (Extended Version)

: This extended type covers a much wider range of years than the standard date type. : If you are linking to an external