Check the Data Type in the Table in Access.

In the Access Table, it shows as a Short Text field!, while I selected Datetime2(3) in SQL Server

Did you say “Yes” on the message box that asks if you wanted to convert DateTime2(3) field in Access? For my database it usually converts the field to Date/Time Extended.

Mine did not convert it, despite I said yes to it. Any idea or any solution?

Any solution for how to fix this issue ? because I still use Datetime instead of Datetime2(3) as Mr Richard recommended

Could you share a screenshot of your table in Design View? Is the table linked from SQL Server?

Dear Alex yes my Table is linked to SQL server