error 3146

[uoghk]

I have a data field "LastChange" type is "SmallDateTime" in a SQL Database table.
In Access Form, I set a textbox Control Source to this field, and Format set to "General Date"


When debug my coding, I see its value is "2023-01-19 10:23:49 AM". I think it is correct & OK.
Then I run Me.Refresh, but I get error 3146, the message is below:
Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding. (#0)
What wrong is that?
Thanks

[Gicu]

This type of error is usually caused by incompatibilities between the SQL Server data types, the ODBC drivers and Access. Change the data type to DateTime and probably the error will go away.

You can do some more searching, but here are some relevant links:

https://nolongerset.com/sql-server-d...lds-ms-access/
https://stackoverflow.com/questions/...-smalldatetime
https://www.tektutorialshub.com/sql-...r%20new%20work.

To get more relevant answers you would need to provide some more details such as SQL driver used, version of SQL server, etc.

Cheers,

[uoghk]

Thanks Gicu