About Dat Time (extended Version) -

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

: Open your table in Design View and select "Date/Time Extended" from the Data Type drop-down menu. 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 : Currently, this data type is only available

The data type is a modernized storage format in Microsoft Access, designed to improve compatibility with external databases and provide higher precision for time-sensitive records. Key Features Using the Date/Time Extended data type - Microsoft

: It supports a higher fractional precision for seconds, making it ideal for records that require extreme accuracy.